close
I am using an IF function to create an array that is a LOOKUP vector:
IF(true,quot;Startquot;,quot;quot;). quot;Startquot; is returned only once in the array yet a LOOKUP
on this array returns the last cell value in the result vector. LOOKUP works
correctly if I remove all if the IF formulas and manually enter quot;Startquot; in
one cell in the lookup vector. It's as if the LOOKUP formula can quot;seequot; the
quot;Startquot; string in every IF function. How can I get LOOKUP to return the
result that corresponds to IF function result?
全站熱搜
留言列表
