Excel 2007 : Using Match to find Find Matches Across 3 Columns

[boohah]

Hi

I need to find a match for 3 separate values on any row of a 3 column table. For example:

Reference Values:

8 9 1

Table:

9 8 1
3 2 3
8 3 3
2 2 3
8 9 1
4 0 1

Only Row 5 contains an exact match on all three rows with each match being in its respective column. I need a formula that will produce only this result. Bear in mind also that the tables I am using contain hundreds of rows.

Any Help would be greatly appreciated

Doug

[Ron Coderre]

See if this gets you headed in the right direction....

With
A1:C10 containing digits

Please Login or Register  to view this content.

and
E1:G1 contains the pattern to match

Please Login or Register  to view this content.

This formula returns the position of the match-pattern in A1:C10

Please Login or Register  to view this content.

In the above example, the formula returns: 5
(The 891 pattern occurs in the 5th row)

Is that something you can work with?

[boohah]

That is definitely something I can use. Thats what I love about this site, every time I get stuck I can always rely on you guys to help me out.

Many Thanks Rons, Much Appreciated.