Is it possible to use Index, Match, as well as If and AND in a Formula?

Hello. I'm brand new to this forum. I'm struggling with a formula that will verify data from 3 different columns in the same row on a different tab.

My exported data, located on my Data tab, has three columns, "Title of Book(column A)," "Read(column B)," and "Name of Person (column C)."

My Read Status tab is where I have table that I would like to compile the data. On this tab, column A (A2 is the first cell, A1 is blank) is the complete roster of every person that should have read the books. B1, C1, D1, etc. are the titles of each book that has been released. I need a formula to check the Data tab for the specific "Title of Book" and then stay on that corresponding row to check for "Read(it should be a yes or no credit is given) and ensure it matches the name on my roster. Can someone help?

=IF(AND(Data!A:A='Sign Off Status'!B$2,Data!$C:$C='Sign Off Status'!A7,Data!B:B="Yes")*TRUE,FALSE)

Hey there Noah, thank you for your reply. My apologies for the delay, I've attached a spreadsheet. Below is the formula I was using trying to obtain a True or False value on the Read Status tab.

=IF(AND(Data!A:A='Read Status'!B$2,Data!$C:$C='Read Status'!A4,Data!B:B="Yes")*TRUE,FALSE)

In B2:

=IFERROR(INDEX(Data!$B$2:$B$13,MATCH(1,('Read Status'!$A2=Data!$C$2:$C$13)*('Read Status'!B$1=Data!$A$2:$A$13),0)),"")

... confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Copy across and down.

or try

B2

Formula:

Please Login or Register  to view this content.

Copy across

You're welcome!