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.
You may try this as well.
=LET(opRange, $G:$G, opNum, $P4, pMonth, U$3,
data, OFFSET(OFFSET($B$1,MATCH(opNum,opRange,0)-1,0),6,0,24,13),
cData, VSTACK(CHOOSECOLS(data,{1,2,3}),CHOOSECOLS(data,{8,9,10})),
INDEX(cData,XMATCH(pMonth,INDEX(cData,,1))+7,COLUMN(B1)))