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...
Hi both, struggling to see the error in the formula, the third argument is referencing a return array B16:AW16 so what am I doing wrong?
Your original formula has two XLOOKUPS:
=XLOOKUP(B3,A13:A16,XLOOKUP(B4,B12:AW12,B16:AW16,"not found",1,1))
The first (outer) XLOOKUP has arguments:
1. Lookup value: B3
2. Lookup array: A13:A16
3. Return array: XLOOKUP(B4,B12:AW12,B16:AW16,"not found",1,1)
The return array argument is an XLOOKUP formula that returns a single value, not an array.