How to extract target value from other cell
Solved/Closed
smuneeb
Posts
67
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
-
Nov 9, 2015 at 03:47 PM
smuneeb Posts 67 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 - Nov 10, 2015 at 01:46 PM
smuneeb Posts 67 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
- The target of the symbolic link does not exist ✓ - Viruses & Security Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Run macro when cell value changes - Guide
- If cell contains text then return value in another cell ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
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