Match Account ID from combining street names and numbers
 

In one sheet, have a column with a street number (A): 115
in Column B, have a street name: Northwest.

In workbook 2, have an additional street number column(C), and a
street name column(D), and a 5th column with an account number, column
(E)
I need to find the account number in workbook 2 for a combination of
street number,and street name found on the given row from the first
workbook.
There can be many street numbers on the same street, but only the
combination of the desired number and called for street should return
a value. Desired combinations are always found on the same row in
either workbook.

Any ideas for me to pursue? Thanks in advance.
Pierre

Match Account ID from combining street names and numbers
 

I figured it out. I concatenated the desired values, thus creating
the desired combinations on each sheet. A simple vlookup did the
heavy lifting.

Thanks for any thought put into this.

Pierre

On Apr 5, 3:37*pm, Pierre wrote:
In one sheet, have a column with a street number (A): 115
in Column B, have a street name: Northwest.

In workbook 2, have an additional street number column(C), and a
street name column(D), and a 5th column with an account number, column
(E)
I need to find the account number in workbook 2 for a combination of
street number,and street name found on the given row from the first
workbook.
There can be many street numbers on the same street, but only the
combination of the desired number and called for street should return
a value. Desired combinations are always found on the same row in
either workbook.

Any ideas for me to pursue? *Thanks in advance.
Pierre