Greetings all
I have been struggling with this most of the day and do not see any reason for the results I am getting. I have some data that has been imported from the company database and I am trying to look up related part numbers from an separate Excel workbook. I have tried Vlookup and Index Match to do the lookup but nothing seems to work. I keep getting a #N/A error.
If I retype the imported values the lookups work, but doing a copy paste values doesn't nor does changing the number format of the imported numbers.
In the attached workbook, the values in column A were imported from the company database and the resulting table converted to a range (after the lookup didn't work on the data formatted as a table). This is just a sample of the data being imported and it is something that I need to be able to turn over to someone else to run so retyping the numbers really isn't an option.
The workbook is in Excel 2010
Any help will be greatly appreciated!
Thanks
Bookmarks