Matching data in multiple colunms

J

Judoguy

I have 6 columns of and 300 rows of data, its 1800 numbers. In bottom row I
want to write 6 numbers and want to search the row which idenically matches
with my numbers, how do I do that?

Thanks allot.
 
T

Toppers

If you mean by "search the row" search FOR the row that matches then try this:

=MATCH(INDEX($A$2:$A$21,MATCH(1,(A24=Acol)*(B24=Bcol)*(C24=Ccol)*(D24=Dcol)*(E24=Ecol)*(F24=Fcol),0)),Acol,0)

Enter with Ctrl+Shift+Enter

Acol= "A" column range i.e A1 to A300: similarly for BCol etc

My data was in columns 2 to 21 with Row 1 being a header row.

My 6 number were in row 24

HTH
 
Top