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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return cell reference instead of value 1
Index/match across multiple columns? 19
How do I find the cell address of the 2nd largest of a set? 4
Look up a reference which has more than 1 exact match 1
Help with Excel Sum Function 3
How to match the values? 3
Match Data in Multiple Columns 2
Match like cells and return the latest date 1

Back
Top