Forum Discussion
Solved
Conditional if/find/lookup formula
Hi, I am trying to build a financial statement template that uses formulas to pull data from another worksheet. The difficulty I am having is finding a formula that will look to a whole sheet of...
Hi Rob,
Array (Ctrl+Shift+Enter) formula INDEX/MATCH could work, for revenue
=IFERROR(INDEX(Data!$D:$D, MATCH(1,(Data!$F:$F=Template!C$2)*(Data!$C:$C=Template!$B4),0),1),0)
and for expenses
=IFERROR(INDEX(Data!$E:$E, MATCH(1,(Data!$F:$F=Template!C$2)*(Data!$C:$C=Template!$B9),0),1),0)
see attached file
Hi Rob,
Array (Ctrl+Shift+Enter) formula INDEX/MATCH could work, for revenue
=IFERROR(INDEX(Data!$D:$D, MATCH(1,(Data!$F:$F=Template!C$2)*(Data!$C:$C=Template!$B4),0),1),0)
and for expenses
=IFERROR(INDEX(Data!$E:$E, MATCH(1,(Data!$F:$F=Template!C$2)*(Data!$C:$C=Template!$B9),0),1),0)
see attached file
Thank you very, very much!
It works :)
Rob
