Multiple conditions using a table and IFS statement (or AND)

[janema]

Can someone tell me how to lookup off a table please? I am trying to create a formula to look up based off the below table. The columns would have to equal D & E to lookup column F.

The formula would go in column O below. I would want to say that if the values in column N match the data in the table column D and if the values in column M match the data in the table column E, then bring back column F from the table. Example: the data in that first cell in column O should bring back "Gabi Shute" because Column M is Isabel Bernal and Column N is Kevin Herde like on the table.

 

[janema]

I will try this again now, thanks. I know you said it would be useful to have an XL2BB copy or a share, but I tried several times and it just won't work for me unfortunately. I think my computer blocks it (work computer).

I really need to learn how INDEX function works because it's so useful and awesome! Thanks again.

 

[etaf]

you are welcome

mrexcel has some youtube videos that may help

https://www.youtube.com/@MrXL/videos

or , i often use

How to use INDEX and MATCH

INDEX and MATCH is the most popular tool in Excel for performing more advanced lookups. This is because INDEX and MATCH are incredibly flexible – you can do horizontal and vertical lookups, 2-way lookups, left lookups, case-sensitive lookups, and even lookups based on multiple criteria. If you...

exceljet.net