Forum Discussion
Formula Help
I need a formula that will return a value with multiple criteria. If P1 is found in column G then from G? return the value in the cell 3 right and 21 down from G? Attached workbook with example.
=OFFSET(INDIRECT("G"&MATCH($P4,$G:$G,0)),21,COLUMN(C$1))An alternative could be this formula.