Thanks Aladin - This is excellent stuff which I will use lots and lots and
lots...! :o)

"Aladin Akyurek" wrote:


=INDEX($A$7:$H$7,MATCH(A1,$A$4:$H$4,0))

=CELL("Address",INDEX($A$7:$H$7,MATCH(A1,$A$4:$H$4 ,0)))

The first formula is equivalent to the HLOOKUP formula that you have.

warrenb wrote:
I am using the HLOOKUP function to find a value in a table.
I also need to confirm the cell reference. I have tried nesting my HLOOKUP
within the OFFSET function, but HLOOKUPs return variables rather than
references.

Here's my (unsuccessful) formula:

=OFFSET(HLOOKUP($A$1,$A$4:$H$13,4,0),0,1)

How can I make a 'lookup' return a cell reference?

Thanks!
Warren