I have two spreadsheets. I am looking for a formula that will Lookup the date and "call type" in Sheet 1 and match those in C & B columns in Sheet 2 and return the value come column C in Sheet 1 for that CODE under the correct sorting and date. I have attached a mockup of what I am working with and hoping someone can assist? Thank you in advance for taking the time to look!
This is what I am currently using, but it's throwing 25 (from my IFERROR)
=IFERROR(INDEX('Data - IB'!C:C,MATCH('Break Out Data'!A3,'Data - IB'!A:A,0),(INDEX('Data - IB'!C:C(MATCH('Break Out Data'!$B$2,'Data - IB'!B:B,0)),22))),25)
Bookmarks