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), bu...
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")