Hello. I need to match two cells on one sheet with 6 cells on a different sheet with as simple a formula as possible to keep the spreadsheet as fast as possible. I am currently using the formula #{=MATCH(1,('MASTER SHEET'!I1590='Scanned Record Data'!B:B)*('MASTER SHEET'!K1590='Scanned Record Data'!C:C),0)}# but the second section "K1590=C:C" needs to compare K1590 with columns C, D, E, F, and G. Can I use an "or" function on that with the and "*"? I have been getting results if the cell in field I1590 matches column B, even if there is no match to the second criteria.