Forum Discussion
Solved
IF Formulas with data from Multiple Cells
Hi there, I need help building a formula with data from two different cells, producing data in a third cell. I originally created a massive IF statement formula, but I believe I maxed out the per...
Hi Jeannelle,
Sorry, MATCH:s shall be in opposite order, wrote formula from picture without the file.
=IFERROR(INDEX(Rates!$B$2:$E$5,MATCH($A2,Rates!$A$2:$A$5,0),MATCH($B2,Rates!$B$1:$E$1,0)),0)
Test file is attached
Hi Jeannelle,
In C2 it could be
=IFERROR(INDEX(Rates!$B$2:$E$5,MATCH($B2,Rates!$B$1:$E$1,0),MATCH($A2,Rates!$A$2:$A$5,0)),0)
Hi Sergei,
I appreciate your formula, but it doesn't seem to be working quite perfectly. For example, if i put Sue & Orange, I am getting a unit rate of $3.50 instead of $2.00
Hi Jeannelle,
Sorry, MATCH:s shall be in opposite order, wrote formula from picture without the file.
=IFERROR(INDEX(Rates!$B$2:$E$5,MATCH($A2,Rates!$A$2:$A$5,0),MATCH($B2,Rates!$B$1:$E$1,0)),0)
Test file is attached
Thank you!!!