MATCH Formula

[Andrea]

I am trying to make a match formula that matches an exact
number in column C with another number in column G. the
match formula matches my number in column C with the first
number in column G. I was wondering if it was possible to
form an exact match with more than one number. That is, I
have two numbers in column G that are the same, and I want
both of them to match with the number in column C. Do you
know how I can do that?

 

[Jason Morin]

This returns the row of the first match between C1 and
G1:G100:

=MATCH(C1,G1:G100,0)

This returns the row of the 2nd match:

=SMALL(IF(G1:G100=C1,ROW(G1:G100)),2)

Array-entered (press ctrl/shift/enter):

Replace the 2 with 3 for the 3rd match, 4 for fourth, etc.

HTH
Jason
Atlanta, GA