damian_r_Home
Board Regular
- Joined
- Jan 8, 2005
- Messages
- 231
- Office Version
- 365
- 2007
- Platform
- Windows
Af'noon All.
Earlier today I put a post (Some sort of lookup function?) which was resolved using this formula
=VLOOKUP(TRIM(RIGHT(C6,LEN(C6)-FIND("~",SUBSTITUTE(C6,"-","~",2)))),Sheet2!$B$6:$D$100,3,0)
If you have a look at the original thread, you will see that it is to do with a partial text string.
I'm now looking for a tweaked version of this formula so that it will pick up the first part of the text string...
Hopefully somebody can help with this.
Regards
D
Earlier today I put a post (Some sort of lookup function?) which was resolved using this formula
=VLOOKUP(TRIM(RIGHT(C6,LEN(C6)-FIND("~",SUBSTITUTE(C6,"-","~",2)))),Sheet2!$B$6:$D$100,3,0)
If you have a look at the original thread, you will see that it is to do with a partial text string.
I'm now looking for a tweaked version of this formula so that it will pick up the first part of the text string...
Hopefully somebody can help with this.
Regards
D