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!