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

Occasional Contributor

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

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