Data import vlookup match fails

[kevmono]

Good evening,

I have an annoying issue with data imports into excel. I may want to match an excel cell in a workbook to bring back values in the exported file saved as excel workbook.
The exported file may have a text value of 002345 and I have an excel worksheet with a value of 2345. In other cases it may be 02345 to match with 2345. Invariably the excel value is formatted as general.
I am looking to match both values in a vlookup and invariably end up using randTrim function, change text to number, import text to columns etc before lookup works.
If there a simple methodology which will ensure I am matching like with like.

I currently do not use languages so if excel functionality is suggested I would be grateful.

As this type of data management takes some effort your support will be gratefully appreciated.

regards

kevin

 

[Trebor76]

Hi kevmono,

Try using an asterisk for "fuzzy" matching on text like so:

=VLOOKUP("*"&A2,Sheet2!B:C,2,FALSE)

Where A2 is numeric but the list in Col. B of Sheet2 is text

Regards,

Robert