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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Just use the cell itself:

=HLOOKUP(A1,A2:K10,3,0)

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

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
 
Not quie sure what you are after here, but here is an explanation of th
HLOOKUP function in non-geek speak.

The layout of this function is -HLOOKUP(a1,$b$1:$c$100,2,true) where A
is the lookup value you are trying to match against the table that i
defined in the next piece between the commas $b$1:$c$100. This define
your table such that the value in cell A1 will exist somewhere i
column B though not neccessarily in B1. Having foud the exact valu
(this is why the word TRUE is used at the end), the formula the
returns the value in the second column (this is the number 2 in th
formula.

I repeat that the number or value (phone number, address etc) HAS TO B
IN THE FIRST COLUMN OF YOUR LOOKUP TABLE and EXACTLY THE SAME - thes
two examples are not the same:
0-15488-4588
0-154884-588

Does this help?
Jo
 
Back
Top