Forum Discussion
Solved
Xlookup and/or Index,Match Help
Greatings and salutations, I have been working on a product, and struggling, for our work schedule that would allow me to put in a start date on the "Weekend Schedule" sheet and automattically pu...
maybe this is overkill:
=LET(datecols,FILTER('Work Schedule'!1:1048576,ISNUMBER(XMATCH('Work Schedule'!2:2,'Weekend Schedule'!D6:G6))), FILTER(HSTACK(Names,datecols),ISNUMBER(SEARCH('Weekend Schedule'!B9,BYROW(datecols,CONCAT)))))so i defined a name called Names for column B
line 1 finds the datecolumns based on the ones used on the sheet
line 2 then combines the names and those columns and then filters based on finding those values.
note there is a potential error if the same person has both "W/D-P" & "W/D-A" in those dates it will show both
It sounds like you might want to check FILTER(). Something like this maybe:
=FILTER( [names], [schedule dates]="W/D-P", "")
Thank you for the tip. I haven't messed with the filter function yet. I'll play around with it to see if I can use it for a final solution.
