Is there any way to use the MATCH function with more than 1 column

M

Mr. Snrub

For example, =MATCH(215, Y3:Y51, 0) will search from Y3 to Y51 for the value
215, but my data set spans more than one column.

My data set ranges from A3 to Z51, and the function =MATCH(215, A3:Z51, 0)
returns an #N/A error. What can I do?
 
G

Gary's Student

In cell A52 enter =MATCH(215,A3:A51,0)
Then copy this formula from B52 through Z52.
If there is only one instance of 215 in the data area, then all the formulae
will show #N/A except one.

For example, if the 215 is in cell C15, then C52 will show 13. Thus we know
that the 215 is in column C and is in the thirteenth row of the data block
(fifteenth row of the worksheet.
 
Top