Forum Discussion
Looking up using three criteria on a table array
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.
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
