| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking up a text string | Excel Discussion (Misc queries) | |||
| can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
| Equation in text string? | Excel Discussion (Misc queries) | |||
| dynamic cell reference within a text string | Excel Worksheet Functions | |||
| How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions | |||
Hybrid Mode
