Data import vlookup match fails

kevmono

New Member
Joined
Feb 9, 2019
Messages
7
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
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Trebor76

Well-known Member
Joined
Jul 23, 2007
Messages
4,783
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
 

Forum statistics

Threads
1,141,068
Messages
5,704,088
Members
421,327
Latest member
Msh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top