dashes in vlookup

[anthonyn]

I am using vlookup to lookup quantities attached to part numbers. Th
formula works fine unless the part number contains a dash (-) then i
will not find the part number in the table array even though they loo
identical.
I have tried formatting the cells in various ways but it has made n
difference.
Any ideas??
Thanks,
Ton

 

[Max]

Assuming only the lookup values contain the dashes "-"

Instead of say, in B1 : =VLOOKUP(A1,Sheet2!A:B,2,0)

Try something like:

=VLOOKUP(--SUBSTITUTE(TRIM(A1),"-",""),Sheet2!A:B,2,0)

Copy down

 

[Dave Peterson]

I've never had trouble with dashes. Is it possible that you have numeric values
formatted to include dashes either in the table or in the lookup value (with the
opposite being text?)

 

[Max]

You're welcome (from us) !
Glad to hear that you got it working
Thanks for the feedback ..