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?