Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedding functions in Vlookup?
On one tab called CheckSheet I have the following:
Check Range 123 XYZ 456 CDR On another tab I have ranges named XYZ and CDR. I need to be able to create a vlookup inside a vlookup. Here is what I am thinking should work but doesn't: +vlookup(z1,+vlookup(a1,'CheckSheet'!A1:B3,2),2) Basically I need a vlookup to use the "range" name that resulted from another vlookup. I am sure there is something simple I am missing but it is driving me crazy. Any help is greatly appreciated. The above results in #value. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedding functions in Vlookup?
try:
=VLOOKUP(Z1,INDIRECT(VLOOKUP(A1,'CheckSheet'!A2:B3 ,2,FALSE)),2,FALSE)) "AsstInterests" wrote: On one tab called CheckSheet I have the following: Check Range 123 XYZ 456 CDR On another tab I have ranges named XYZ and CDR. I need to be able to create a vlookup inside a vlookup. Here is what I am thinking should work but doesn't: +vlookup(z1,+vlookup(a1,'CheckSheet'!A1:B3,2),2) Basically I need a vlookup to use the "range" name that resulted from another vlookup. I am sure there is something simple I am missing but it is driving me crazy. Any help is greatly appreciated. The above results in #value. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Embedding functions in Vlookup?
Try...
=VLOOKUP(Z1,INDIRECT(VLOOKUP(A1,'CheckSheet'!A1:B3 ,2)),2) Hope this helps! In article , AsstInterests wrote: On one tab called CheckSheet I have the following: Check Range 123 XYZ 456 CDR On another tab I have ranges named XYZ and CDR. I need to be able to create a vlookup inside a vlookup. Here is what I am thinking should work but doesn't: +vlookup(z1,+vlookup(a1,'CheckSheet'!A1:B3,2),2) Basically I need a vlookup to use the "range" name that resulted from another vlookup. I am sure there is something simple I am missing but it is driving me crazy. Any help is greatly appreciated. The above results in #value. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible to combine VLOOKUP and IF(AND) functions? | Excel Worksheet Functions | |||
Vlookup + Address functions combined | Excel Worksheet Functions | |||
Updating Functions (Vlookup) | Excel Worksheet Functions | |||
Nesting VLOOKUP functions | Excel Worksheet Functions | |||
VLOOKUP and ISNA functions | Excel Worksheet Functions |