vlookup returning #value!

[nba]

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

 

[Eduardo]

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

 

[JLatham]

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().

 

[JLatham]

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)),WEEKDAY(D11)+2, FALSE)

I believe it'll work for you then.