LOOKUP a text string created from IF statement

S

Steve-in-austin

I am using an IF function to create an array that is a LOOKUP vector:
IF(true,"Start",""). "Start" 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 "Start" in
one cell in the lookup vector. It's as if the LOOKUP formula can "see" the
"Start" string in every IF function. How can I get LOOKUP to return the
result that corresponds to IF function result?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup Question 4
Lookup function help required. 0
If Function neglecting 0 as a number 1
LOOKUP problem with non-sorted vector 3
LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU 5
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Looking for LOOKUP variation 5
Lookup Function Problem 9

Top