Forum Discussion
Two way vertical and horizontal lookup
I want a formula to lookup a date, establish whats it falls onto using the week ending date, match that against the employee name and return the intersecting value. For example, I want to see Jam...
In principle, what you are doing is correct.
= XLOOKUP(
name,
employee,
XLOOKUP(d,wkEnding,hours,"",1)
)so the problem is in the detail. Maybe looking up a numeric datavalue against a text date.