Looking up using three criteria on a table array

New Contributor

I’m an excel noob. I’m trying to look-up data using multiple criteria (name, day, time). I have attached an example of what I’m trying to do.

Can the excel pros help me with the formula or other ways to do this? I’ve read up on index, match, lookups but I can’t make it happen.
1 Reply


It's better to attach Excel file instead of PDF. As variant formula could be

=XLOOKUP($C$11&$B14, $B$4:$B$7&$C$4:$C$7, XLOOKUP(C$13,$D$3:$I$3,$D$4:$I$7) )

and drag it to the right and down