I can't say why this isn't working for you, it seems ok to me. How about
trying:

=HLOOKUP(TEXT(B2,"ddddd"),C7:I8,2,0)

Hope this helps
Rowan

"Mike K" wrote:

Oh wise ones,
I thought I had it, I really thought I had it this
time. Ok, so I have my data as follows;

B2 =Today() which as of right now is Sunday
E2 =Lookup(Text(B2,"ddddd"),C7:I7,C8:I8) vector based
C7:I7 Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday
C8:I8 C A A C C A A

If B2 is "Sunday" and I7 contains "Sunday", should'nt E2 return "A" from I8?
Why is it returning "C"?

The equation builder shows "Sunday" for the lookup value. So I'm not sure
whats wrong. I know B2 is really a whole number, but I thought the "TEXT"
function in E2 was accounting for that. Please advise

Thanks, Mike