Lookup to return first x characters of result

[CookieMonster76]

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

 

[tyija1995]

Hey,

try:
=LEFT(IF(ISNA(VLOOKUP(B183,'Sheet2'!A:T,20,FALSE)),"",VLOOKUP(B183,'Sheet2'!A:T,20,FALSE)),8)

 

[AlanY]

can't you use the =left(your formula here,8) to get the first 8?

 

[AlanY]

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

you might be able to simplify the formula to

=iferror(VLOOKUP(B183,'Sheet2'!A:T,20,FALSE),"")