Exactly!

You're welcome!

--
Biff
Microsoft Excel MVP


"Karen53" wrote in message
...
Hi T. Valko,

Never mind. I get it. The wild card would have to be on E346 to make up
for the missing chars.

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