=Vlookup("ABCD",LEFT(A1:B200,5),2,0)
I have a 5 character code in one worksheet and
on the other worksheet, that code is followed by
a - and then a name.

Try it like this:

=INDEX(B1:B200,MATCH("abcde-*",A1:A200,0))

Or, using a cell to hold the lookup value:

D1 = abcde

=INDEX(B1:B200,MATCH(D1&"-*",A1:A200,0))

--
Biff
Microsoft Excel MVP


"Jneel" wrote in message
...
Hi, need help. I have searched the discussion threads and, in theory,
found
what I needed, however it will not work for me. I get a #value
No matter what I do, I cannot get rid of the #value. I found the below
function formulas that I need and do not work for me.

I have a 5 character code in one worksheet and on the other worksheet,
that
code is followed by a - and then a name. I just want to use a LEFT to
gather
the needed data.

Does anyone know what I am missing here?

=Vlookup("ABCD",LEFT(A1:B200,5),2,0)

=VLOOKUP(Left(A1,FIND(",",A1)-1),YourTableOfData,YourValueToReturnCol,0)
That will take the EE-A from "EE-A, FlexMed ($25.00)" and find that value
in
your table.
Thanks for your help.