Increment one cell reference when copying formula

  • Thread starter Thread starter Sheryl
  • Start date Start date
S

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