vlookup and format

[dashingdude]

Help please.

I am trying to obtain price of an item using vlookup() function on the identifier “0003128” (7 digits) stored with “custom” format “0000000” in one worksheet. However in other worksheet, the identifier is stored as “000312” (6 digits) with “text” format without the last digit ‘8’. I tried using the left(A,6) function on “0003128” but instead of returning “000312” it returns “3128” and I’m unable to use the vlookup() function. Please help.

Thanks!

[daddylonglegs]

Try changing the lookup value to

=LEFT(TEXT(A1,"0000000"),6)

[VBA Noob]

dashingdude,

Cross posting is not permitted. Please read forum rules below and if you agree to them PM me and I will unlock the thread

VBA Noob