Forum Discussion
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
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")
