Hi everyone,

I am having some trouble matching up part numbers to try to pull a quantity.

For some background: there is a customer file which contains 6 different columns. Each row has its own part number and each column is simply an alternative part number if applicable, meaning there are a good amount of blanks as well.

In the file that I am working on, we have a similar set up, but with only 5 columns of possible part numbers.

Is it possible for me to have one column from my file perform a match against every column in the other file and repeat for the other 4 in my file until a match is found?

The problem that I am running into is that since there are so many data points, it is very time consuming and potentially inaccurate for me to VLOOKUP each one.

Thank you in advance!