title: Excel data validation not able to make indirect to work with if function, along with indirect I am trying to use row function
body: <p>Below formula working fine with fixed value to indirect function "$B$2"    </p>
  
  <pre><code>=IF(INDIRECT("$B$2")="",SubBusinessList,INDEX(SubBusinessColumn,MATCH($B$2,AppIdsColumn,0)))
  </code></pre>
  
  <p>But if I use <code>ROW()</code> instead of 2 in "$B$2" its not working.
  Below formula is not working.</p>
  
  <pre><code>=IF(INDIRECT("$B$"&amp;ROW())="",SubBusinessList,INDEX(SubBusinessColumn,MATCH($B$2,AppIdsColumn,0)))
  </code></pre>
  
  <p>Where I am doing wrong any suggestions.
  Thanks in advance.</p>