Forum Discussion
Solved
Conditional Column and Row information pull formula help
Hello, I need help pulling data in a formula where I have a table of information, cost type along the columns (R&M, Salaries etc) and GL String code along the rows. I can pull the data using ...
Hi Michael,
The formula could be like
=SUMPRODUCT(($D$2:$D$11=$B17)*INDEX(OFFSET($E$2:$E$11,0,MATCH($C17,$E$1:$K$1,0)-1),0))
First multiplier checks the code, second one selects the column based on MATCH shifting it from first one (E) by OFFSET
Please see attached
Hi Michael,
The formula could be like
=SUMPRODUCT(($D$2:$D$11=$B17)*INDEX(OFFSET($E$2:$E$11,0,MATCH($C17,$E$1:$K$1,0)-1),0))
First multiplier checks the code, second one selects the column based on MATCH shifting it from first one (E) by OFFSET
Please see attached
Thanks very much