Hi all,

What I'm trying to do is check to see if a cell (A2) from worksheet A
is within a range from worksheet B. Then, if true, need to compare the
next two cells (B2,& C2) in worksheet A to see if they are the same as
the next two cells from the range in worksheet B. This is what I have
thus far:

=IF(ISNA(VLOOKUP(A2,Range 1,1,FALSE)),"ID No
Match",IF(AND(ISNA(VLOOKUP(B2,Range 2,1,FALSE)),(ISNA(VLOOKUP(C2,Range
3,1,FALSE)),(((AND(B2=B10,C2=C10)),"No Change","Salary Change")))

The issue I'm having is, how do you compare the next two cells from the
row the first lookup found in worksheet B with row where the formula in
on in worksheet A?

Any help is much appreciated.

Gerry