Cell contents as the 'lookup value' parameter in HLOOKUP function

Tech-Archive recommends: Fix windows errors by optimizing your registry

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
.

Relevant Pages

  • HLookUp
    ... I want to use the hlookup function but the data I need to look up ... has the lookup value at the bottom row rather than the top. ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: adapting the findnext function
    ... > in via a lookup, is there anyway to make excel think they are just there ... > chrisrowe_cr's Profile: ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: IF/WHEN forumla fo when a cell is between two numbers
    ... One way is to just reverse your scrip: ... Another method, which is more flexible, is to use a lookup table. ... can, if necessary, expand the formula to include many levels of conditions. ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Lookup from text file
    ... the textfile to the table and try to define a lookup. ... how do I reference the columns of the text file? ... Stijn Verrept. ... Prev by Date: ...
    (microsoft.public.sqlserver.dts)
  • Re: Cell contents as the lookup value parameter in HLOOKUP function
    ... HLOOKUP function in non-geek speak. ... The layout of this function is -HLOOKUPwhere A1 ... IN THE FIRST COLUMN OF YOUR LOOKUP TABLE and EXACTLY THE SAME - these ... Jon Quixley ...
    (microsoft.public.excel.misc)