I am looking for help with a formula. Write now if Sheet1 has a €œ10€� in cell
K4, and I put this formula {=IF('Sheet1'!K4="10",1,""} in cell P4 the number
€œ1€� will be displayed in cell P4. I wanted to modify the formula so that if
cell J4 displays €œApples€� and K4 displays €œ10€� (assuming I put the formula in
P4 again) a €œ1€� will be displayed in cell P4. Thank you for your ideas.