Matching data in multiple colunms
 

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.

Matching data in multiple colunms
 

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=Bc ol)*(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

"Judoguy" wrote:

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.