Hi,

Thank you!

Yes, it worked but it doesn't seem to make sense. The wild card applies to
the range even though it is attached to E346? Would you give me the logic
behind it? I'd like to understand what is happening.

Thanks again!
--
Thanks for your help.
Karen53


"T. Valko" wrote:

I took your suggestion and modified it but it is not working.

Try it *just* like I posted it!

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


--
Biff
Microsoft Excel MVP


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