Forum Discussion

tgeer72's avatar
tgeer72
Copper Contributor
May 06, 2019

Is it possible for excel to recognize text in one cell to generate value of another cell?

I'm new at the more intermediate functions of excel - so please bare with me. Here's my question. Can you determine the value of a cell on one tab based on the text of a cell on a different tab.   ...
excel
Formulas and Functions
Twifoo's avatar
Twifoo
Silver Contributor
May 06, 2019

tgeer72 

I suggest you modify the layout of your data, similar to the attached file. The formula in I3, copied down rows and across columns, is: 

=SUMPRODUCT(($E$2:$E$25*($C$2:$C$25=$H3)*($D$2:$D$25=I$2))-
($E$2:$E$25*($B$2:$B$25=$H3)*($D$2:$D$25=I$2)))