Increment one cell reference when copying formula

[Sheryl]

I have one worksheet containing names and qualifications,
and another containing positions and qualifications. I
want to match the people with the positions based on
qualifications on a third worksheet. Each person may
qualify for multiple positions. There are 26 positions,
200 personnel and 21 separate qualifications to match. I
have tried using a nested IF function, which works, but I
need to increment the function by row number for each
person in the list without changing the other cell
reference for matching.

Example: I am testing for a match of C2 to C2 for the
person in row 2; for the person in row 3 I want the match
to read C3 to C2. The second cell reference doesn't
change.

Any help you can give would be appreciated.

 

[Frank Kabel]

Hi
maybe something like
='sheet1'!$C$2=C2

 

[Mary]

In excel, you may be able to use the formula =OR(EXACT(TestValue, CompareRange)). (Type in 'compare one value to a list of values' in your help query, and you will see an explanation.)

I also know you can do this in access.

M