I need help working out a formula.
In the table below, I need a way to find what the status is for a specific venue at a specific time. So for example, if I wanted to know what the status was of McDonalds at 3PM, I need a formula that finds the row in which the venue is ‘McDonalds’ and the time is ‘3PM’, then returns the status, which in this case would be ‘reserved’.
I feel like I’m circling the answer but I can’t work out how to make it work.
| Venue | Time | Status |
|---|---|---|
| McDonalds | 2PM | Open |
| McDonalds | 3PM | Reserved |
| McDonalds | 4PM | Sold |
| Burger King | 2PM | Open |
| Burger King | 3PM | Open |
| Burger King | 4PM | Sold |
| Taco Bell | 2PM | Reserved |
| Taco Bell | 3PM | Open |
| Taco Bell | 4PM | Reserved |
I’ve been looking at If/And statements, xlookups, and index/Match (which I’m not very good at), but I haven’t been able to crack it. I keep getting spill errors.
Nathan Sinclair is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1