CookieMonster76
Board Regular
- Joined
- Apr 30, 2015
- Messages
- 201
Hi
I have a simple lookup:
=IF(ISNA(VLOOKUP(B183,'Sheet2'!A:T,20,FALSE)),"",VLOOKUP(B183,'Sheet2'!A:T,20,FALSE))
However, the result (i.e. the data in Col T had 9 characters, but I need the lookup to only display the first 8 characters. Is there a way to do this?
Thanks
Paul
I have a simple lookup:
=IF(ISNA(VLOOKUP(B183,'Sheet2'!A:T,20,FALSE)),"",VLOOKUP(B183,'Sheet2'!A:T,20,FALSE))
However, the result (i.e. the data in Col T had 9 characters, but I need the lookup to only display the first 8 characters. Is there a way to do this?
Thanks
Paul