need formula help

[HUSKER55]

what is the formula to return the row number when you know the value and the column number?

value is in cell d4
the table is on another sheet "data" $a$1:$g$10
row number is 7


thanks

[098poi]

I Googled your question and here is one page that may help. Gave me a headache but may be a good reference for you anyway.
http://www.globaliconnect.com/excel/index.php?option=com_content&view=article&id=72:last-used-row-number-cell-address-numeric-or-text-value&catid=77&Itemid=473

[HUSKER55]

in my post the COLUMN NUMBER is 7. I am looking for the row number. CHRIST I EVEN GOT MY QUESTION BACKWARDS. GUESS WHO IS NOT BETTING TODAY :D


thanks for your efforts but I am going straight for the vickadin WITH SOME HELP FROM MY GOOD BUDDY JIMMY BEAM :D

[Ray2000]

This should work but don't "bump the table" :)


=MATCH(D4,INDIRECT(ADDRESS(1,A1,,,"data")&":"&ADDRESS(10,A1)),0)


A1 contains the column number
D4 contains the value