Comparing two Excel Files

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I am pretty new to formulas and such and don't have a very good understanding
of them. Here is what I am trying to do.

I have two Excel worksheets. Both files have a column in common, but one
worksheet doesn't contain a complete list of the same information that
worksheet 2 does. I want to find the same info in the cells of a column from
worksheet 1 from worksheet 2 and report info of a cell to the right of that
matching info from worksheet 2 to worksheet 1. (Does this make sense?)

If so, what would be the best and easiest way to do this?
 
One play using index/match

Assume the match col in both sheets is col B,
with the desired col to be retrieved (in Sheet1) being col C in Sheet2

In Sheet1,
Put this in C2:
=IF(ISNA(MATCH($B2,Sheet2!$B:$B,0)),"",INDEX(Sheet2!C:C,MATCH($B2,Sheet2!$B:$B,0)))
Copy C2 down as far as required to return col C of Sheet2. Unmatched cases
will return blanks: "".

(As-is, you could just copy C2 across if you want to return cols D, E, F of
Sheet2)

Adapt to suit ..
 
Back
Top