Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup returning #value!
I have dates in on table and prices in another
using the formula VLOOKUP(H9,VLOOKUP(F11,Dates,2,FALSE),WEEKDAY(D11) +2,FALSE) table names are "low" "mid" and "high" VLOOKUP(F11,Dates,2,FALSE) returns "low" but when nested within the vlookup I get #value! please help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup returning #value!
Hi,
could you give a sample of your data and what exactly you want to achieve, the second part of the formula make no sense as it "nba" wrote: I have dates in on table and prices in another using the formula VLOOKUP(H9,VLOOKUP(F11,Dates,2,FALSE),WEEKDAY(D11) +2,FALSE) table names are "low" "mid" and "high" VLOOKUP(F11,Dates,2,FALSE) returns "low" but when nested within the vlookup I get #value! please help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup returning #value!
As a first step, your outside VLOOKUP() is missing the column to return data
from parameter. It should be something like: VLOOKUP(H9,VLOOKUP(F11,Dates,2,FALSE),WEEKDAY(D11) +2, ##, FALSE) the missing part is the ##, that I added, which of course should be a column number from the table whose name is being returned by the nested VLOOKUP(). "nba" wrote: I have dates in on table and prices in another using the formula VLOOKUP(H9,VLOOKUP(F11,Dates,2,FALSE),WEEKDAY(D11) +2,FALSE) table names are "low" "mid" and "high" VLOOKUP(F11,Dates,2,FALSE) returns "low" but when nested within the vlookup I get #value! please help |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup returning #value!
Oops - actually I misread your formula, and I see that
WEEKDAY(D11)+2 is filling the requirement that I thought was missing. Instead!! Wrap the nested VLOOKUP with INDIRECT(), as VLOOKUP(H9,INDIRECT(VLOOKUP(F11,Dates,2,FALSE)),WE EKDAY(D11)+2, FALSE) I believe it'll work for you then. "JLatham" wrote: As a first step, your outside VLOOKUP() is missing the column to return data from parameter. It should be something like: VLOOKUP(H9,VLOOKUP(F11,Dates,2,FALSE),WEEKDAY(D11) +2, ##, FALSE) the missing part is the ##, that I added, which of course should be a column number from the table whose name is being returned by the nested VLOOKUP(). "nba" wrote: I have dates in on table and prices in another using the formula VLOOKUP(H9,VLOOKUP(F11,Dates,2,FALSE),WEEKDAY(D11) +2,FALSE) table names are "low" "mid" and "high" VLOOKUP(F11,Dates,2,FALSE) returns "low" but when nested within the vlookup I get #value! please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP always returning the same value! | Excel Discussion (Misc queries) | |||
Vlookup returning a YES or NO | Excel Worksheet Functions | |||
Vlookup returning #n/a | Excel Worksheet Functions | |||
vlookup returning a #N/A value | Excel Worksheet Functions | |||
vlookup returning sum | Excel Worksheet Functions |