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.
What you have so far is working perfectly. I was trying to apply another criteria I need which is what we have so far, plus a date then return X value. I added it to the workbook and what I'm looking for.
=OFFSET(INDIRECT("G"&MATCH($P4,$G:$G,0)),MATCH(W$3,INDIRECT("I"&MATCH($P4,$G:$G,0)&":I"&MATCH($P4,$G:$G,0)+30),0)-1,5)You can try this formula which returns the expected results for the sample data in my sheet.