Have a look at MATCH and then at INDEX
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Dave White" wrote in message
...
No. Respectfully, I do not think you understand what I need.
I need a function that returns the ROW, COL position (better word) of a
TABLE value.
LOOKUP gives me the TABLE value of a ROW, COL position.
"Bernard Liengme" wrote:
LOOKUP?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Dave White" wrote in message
...
Excel Lookup functions normally return a Table value based on a
row,column
search criteria. I need to return the row, column based on the table
value.
Any ideas Appreciated,
Thanks in Advance