Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
Return cell contents based on conditional lookup | Excel Worksheet Functions | |||
Return cell reference of lookup value | Excel Worksheet Functions | |||
change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
up to 7 functions? | Excel Worksheet Functions |