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.