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