Just use the cell itself:
=HLOOKUP(A1,A2:K10,3,0)
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"EMarre" wrote in message
...
To anyone that could help me, I have the following question which I would
appreciate any answer in advance.
How can I use the contents of a cell (which I will change constantly) as the
'lookup value' parameter in an HLOOKUP function?
Example:
Cell A1 contains the value 'FY06DRN74DZ' (this are budget names I use to
identify files)
HLOOKUP ('lookup_value' = makes a reference to contents of cell A1.....
and changes as I change the value of A1.
Thanks again,
E Marre
|