Aug 09 2019 11:29 AM
Aug 09 2019 12:23 PM
@Jbones hello there.
You could use something like this:
=IFERROR(INDEX(Sheet1!G1:G10,MATCH(1,MMULT(--(D5=Sheet1!A1:C10),TRANSPOSE(COLUMN(Sheet1!A1:C10)^0)),0)),"Not Found")
This is an array formula, known as a CSE, or a CONTROL+SHIFT+ENTER formula. Don't confirm with just ENTER. When you confirm the formula entry, ensure it's the only cell selected. Here is a good explanation of the formula:
https://exceljet.net/formula/index-and-match-on-multiple-columns
If you don't want to use an array formula, you'll need to enter the ranges individually, something like this:
=IFERROR(INDEX(Sheet1!G1:G10,MAX(IFERROR(MATCH($D5,Sheet1!A1:A10,0),-1),IFERROR(MATCH($D5,Sheet1!B1:B10,0),-1),IFERROR(MATCH($D5,Sheet1!C1:C10,0),-1))),"Not Found")
In both of these formulas, you can see I assumed the range was in rows 1 through 10, and the sheets were default names. Adjust formula accordingly to your data.
HTH