Will vlookup work when there are duplicate entries in both spreadsheets? For example, in the spreadsheet where the vlookup formula is located, I go to the part number column to lookup the part number. In this column there are multiple entries of the same part number. I then go to a second spreadsheet to find that same part number (also having multiple entries of the same part number) and find the corresponding price to put in a column in the spreadsheet where the vlookup formula is.
When I spot check the #N/As, I find that the part number exists in the spreadsheet I'm doing the lookup in.
I'm sure the multiple entries are causing the problem, but I don't know how to get around the problem.
Any help would be appreciated.
When I spot check the #N/As, I find that the part number exists in the spreadsheet I'm doing the lookup in.
I'm sure the multiple entries are causing the problem, but I don't know how to get around the problem.
Any help would be appreciated.