How to get a return of specific column and relative row in excel?

Copper Contributor

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

1 Reply

@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")