Using Excel 2000
I want a formula to find a cell containing a specified value and then return
the cell address for that cell so that I can use that address to define a
range for another formula. Hlookup provides the value. Match provides the
position. How can I find the address without already knowing the address?

Thank You,