LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Name ranges and Lookup

If my lookup ranges are named, can I use the name of the range in a cell then
point to the cell as my lookup table?

Example:

=vlookup(H5,D1,2) where,

H5 = lookup value
D1=CRC
CRC=Position!$A$1:$B$6


I know that I can use the name directly in my formula, however, I have
several named ranges. The use of a specific range is determined by a certain
criteria (i.e., CRC position would use CRC range, CNII position would use
CNII range). What I was hoping to do was list the appropriate range name in
a column then create one vlookup formula (that points to that column) and
copy down.

Any suggestions or feedback is appreciated!

 
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
Mass Creation of Named Ranges? [email protected] Excel Discussion (Misc queries) 7 July 11th 06 08:41 AM
Referencing Named Ranges ExcelRookie Excel Worksheet Functions 2 March 6th 06 12:50 PM
Lookup Value between 2 ranges Dominique Feteau Excel Worksheet Functions 2 November 1st 05 06:17 PM
lookup function 1 Colboyfx Excel Worksheet Functions 4 July 15th 05 09:15 AM
Ranges with in a LOOKUP Elijah Excel Worksheet Functions 2 November 23rd 04 10:40 AM


All times are GMT +1. The time now is 10:51 PM.

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

About Us

"It's about Microsoft Excel"