Hello,

Try it as an array formula?

{=index($G$36:$G$336,match(1,($E346=left($E$36:$G$ 336,9)),0))}


HTH,
JP

On Oct 19, 2:36 pm, Karen53 wrote:
Hi,

Thank you for your reply.

Cell E346 is complete. I'm actually trying to E346 to the left 9 char of
E36:G336. I took your suggestion and modified it but it is not working.

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

I tried it with Match as well
=IF($E346<"",INDEX(G36:G336,MATCH($E346,$E36&"*": $E336&"*",9),0),""))

--
Thanks for your help.
Karen53



"T. Valko" wrote:
Try it like this:

=IF($E346<"",VLOOKUP($E346&"*",$E36:$G336,3,0),"" )

The "*" is a wildcard.

--
Biff
Microsoft Excel MVP

"Karen53" wrote in message
...
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- Hide quoted text -

- Show quoted text -