| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Name ranges and Lookup
Maybe...
=vlookup(h4,indirect(d1),2) eionjess wrote: 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! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Name ranges and Lookup
=VLOOKUP(H5,INDIRECT(D1),2,0)
"eionjess" wrote: 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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Name ranges and Lookup
That's it!! Thank you, both!!
"Teethless mama" wrote: =VLOOKUP(H5,INDIRECT(D1),2,0) "eionjess" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mass Creation of Named Ranges? | Excel Discussion (Misc queries) | |||
| Referencing Named Ranges | Excel Worksheet Functions | |||
| Lookup Value between 2 ranges | Excel Worksheet Functions | |||
| lookup function 1 | Excel Worksheet Functions | |||
| Ranges with in a LOOKUP | Excel Worksheet Functions | |||
Linear Mode
