How to extract target value from other cell
Solved/Closed
smuneeb
Posts
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
-
Nov 9, 2015 at 03:47 PM
smuneeb Posts 77 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 - Nov 10, 2015 at 01:46 PM
smuneeb Posts 77 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 - Nov 10, 2015 at 01:46 PM
Related:
- How to extract target value from other cell
- Extract audio from video - Guide
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- If cell contains specific text then return value in another cell vba ✓ - Excel Forum
- Excel if cell contains date then return value ✓ - Office Software Forum
- If cell contains text then return value in another cell ✓ - Excel Forum
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
Nov 10, 2015 at 11:07 AM
Nov 10, 2015 at 11:07 AM
Hi Smuneeb,
If Target refers to column C, but you like the value from column B then use:
target.offset(0,-1)
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
If Target refers to column C, but you like the value from column B then use:
target.offset(0,-1)
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
Nov 10, 2015 at 01:46 PM
Thanks
keep me in good book