LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
EMarre
 
Posts: n/a
Default Cell contents as the 'lookup value' parameter in HLOOKUP function

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conversion of Cell Contents into a Functional Worksheet name ? GMJT Excel Worksheet Functions 1 August 21st 05 04:59 PM
Return cell contents based on conditional lookup jarviscars Excel Worksheet Functions 15 August 5th 05 08:05 AM
Return cell reference of lookup value bobm Excel Worksheet Functions 3 July 7th 05 08:49 AM
change cell shading whenever contents different from previous cell zooeyhallne Excel Discussion (Misc queries) 3 June 6th 05 09:59 PM
up to 7 functions? ALex Excel Worksheet Functions 10 April 12th 05 06:42 PM


All times are GMT +1. The time now is 10:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"