On Sunday, June 30, 2013 7:18:12 PM UTC-7, arceaf wrote:
Hi,



I'm trying to build a formula that will count the position of a cell

relative to a list. You'll find a pic attached.



When I select "34" from the drop down menu, the table automatically

populates cell h10 with the #34. I need to know what position 34 is

relative to the list (report 34 would be the second report on the list)



How can I do this? The match function does not work.



Thank you!





+-------------------------------------------------------------------+

|Filename: match function with numbers.JPG |

|Download: http://www.excelbanter.com/attachment.php?attachmentid=886|

+-------------------------------------------------------------------+

This works for me.

In J10 =MATCH(H10,B4:B10,0)
In H10 =E7
In E7 is a drop down with the values listed in B4:B10

When E7 shows 34 J10 returns 2.

Regards,
Howard