In message of
Sun, 30 Jun 2013 22:10:21 in microsoft.public.excel.worksheet.functions,
writes
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

What version of Excel MAY be relevant. I use 2003.
I duplicated Howard's experience.
I suggest you might try stepping through the code.
Tools\Formula Auditing\Evaluate Formula.
For me it is 2 steps.the first calculates 34, the second 2.
--
Walter Briscoe