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