Looking up and matching data
 

I have two sets of data with the same information but not in the same order
and am trying to match the data. In each data set I have 10 pools containing
100 loans. Each pool has a unique ID and each loan within the applicable
pool has an ID of 1 to 100. I need to look up the Pool ID, then look up the
loan ID so that I can extract the property type information from a third
column. The Pool ID and property type is text but the loan ID is a number.

I am struggling to put together the right combination of formulas to give
the property type for each loan within each pool. Any suggestions would be
greatly appreciated.

Looking up and matching data
 

Create a 'cheater' column in each of your 2 sets of data.
The cheater column combines the pool id and the loan id.
Ex: Assume pool id is in Col A and loan id is in Col B and the data starts
in row 2.
In your cheater column, in row 2 put the formula =A2 & B2
Now use a vlookup( ) formula to look up the property type info

Hope this helps,
Sincerely,
Gary Brown


"HRHRLBS" wrote:

I have two sets of data with the same information but not in the same order
and am trying to match the data. In each data set I have 10 pools containing
100 loans. Each pool has a unique ID and each loan within the applicable
pool has an ID of 1 to 100. I need to look up the Pool ID, then look up the
loan ID so that I can extract the property type information from a third
column. The Pool ID and property type is text but the loan ID is a number.

I am struggling to put together the right combination of formulas to give
the property type for each loan within each pool. Any suggestions would be
greatly appreciated.

Looking up and matching data
 

Gary,

Thank you - very helpful. Now if I can just figure out why I get #Value!
result when I combine the two columns I can move ahead.

"Gary Brown" wrote:

Create a 'cheater' column in each of your 2 sets of data.
The cheater column combines the pool id and the loan id.
Ex: Assume pool id is in Col A and loan id is in Col B and the data starts
in row 2.
In your cheater column, in row 2 put the formula =A2 & B2
Now use a vlookup( ) formula to look up the property type info

Hope this helps,
Sincerely,
Gary Brown


"HRHRLBS" wrote:

I have two sets of data with the same information but not in the same order
and am trying to match the data. In each data set I have 10 pools containing
100 loans. Each pool has a unique ID and each loan within the applicable
pool has an ID of 1 to 100. I need to look up the Pool ID, then look up the
loan ID so that I can extract the property type information from a third
column. The Pool ID and property type is text but the loan ID is a number.

I am struggling to put together the right combination of formulas to give
the property type for each loan within each pool. Any suggestions would be
greatly appreciated.