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