Hi,

I'm having trouble figuring out how to do this. I need to look up the value
in E346 (9 char long) and compare it to just the left 9 characters in my look
up range and return the value in column G. E is a string. G is a number.

Here's a couple I've tried:

=IF($E346<"",VLOOKUP($E346,LEFT($E36:$G336,9),3,F ALSE),"")

=IF($E346<"",INDEX(G36:G336,MATCH($E346,LEFT($E36 :$E336,9),0),""))

Can this be done?

--
Thanks for your help.
Karen53