![]() |
LOOKUP a text string created from IF statement
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? |
All times are GMT +1. The time now is 06:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com