Hello,

I have an application in which I'd like to match up data from two large
spreadsheets, lists of addresses. One of the lookup variables, a customer
code is in a single column, column A, but the second is in one of 5 columns.
There are several addresses for a given customer code, so I need a formula to
meet both criteria, and then return a value called the address code, which is
in a different column than those listed above.

I have been experimenting with VLOOKUP, INDEX, and MATCH functions, but the
fact that the address I need to match up to can be in any one of five columns
is making it difficult to tell excel what value to return.

Any help would be appreciated.