Oct 25 2021 01:39 AM
Dear experts
For example, when I insert this formula ="E"&ROW() in a certain cell, I get E52 in return.
Then I want to use this formula within another formula: =IF(("E"&ROW())="EXAMPLE",Yes), but it just doesn't work and return the value as invalid
Is there any way to do this easily?
Thank you
John Doe
Oct 25 2021 02:05 AM
@pjuvish Use INDIRECT like this (and put quotation marks around the Yes and i assume you want No if the condition is not met)
=IF(INDIRECT("E"&ROW())="EXAMPLE","Yes","No")