=IFERROR(IF(WEEKDAY(SelectecmISD)=VLOOKUP(VLOOKUP(B12,'XD Routing'!B:L,11,FALSE),buffer!$A$19:$B$25,2,FALSE),"X",""),"E")
This is the formula in question. Let me break it down a little...
First section (between the two ='s) SelectecmISD is a named range (with a typo...) for the Selected IS date. It references a cell that containes a date value. I want to extract the Weekday value of this range (1-7) and compare it against:
VLOOKUP(VLOOKUP(B12,'XD Routing'!B:L,11,FALSE),buffer!$A$19:$B$25,2,FALSE),"X",""),"E")
B:L on 'XD Routing' contains a table, in which a value matching B12 is listed somewhere. Column L contains a day typed in the General format as "FRIDAY", "MONDAY" etc, which is associated with the value in B12
The second lookup is comparing what day was found to another small table on the 'buffer' sheet, which is a simple 7 row 2 columns with the days and the Weekday associated with them (1,2,3,4,5,6,7)
End result is I want to compare the day associated with the value in B12 with a day located in the named range SelectecMISD, returning an X if they are the same (1=1, 2=2, 3=3 and so on) or nothing if not true. So far all I get is an E.
I have broken the formula in half and tested that way, seemed to work...not sure why it doesn't work within one cell.
Well that got confusing. Unfortunately I cannot upload this particular file...
Thanks for looking!
Bookmarks