Looking up and matching data

  • Thread starter Thread starter HRHRLBS
  • Start date Start date
H

HRHRLBS

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.
 
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
 
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.
 
Back
Top