Have you looked in the HELP index for LOOKUP, vLOOKUP,hLOOKUP

--
Don Guillett
SalesAid Software

"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