Looking up using three criteria on a table array

New Contributor
Hi!

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

@excelnewbie444 

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

image.png