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

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?

Do you want both the row and column ? Two separate values?
--
Gary's Student


"Mr. Snrub" wrote:

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?

yes

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.
--
Gary's Student


"Mr. Snrub" wrote:

yes

great. thank you.