| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup
What's wrong with this formula?
Forecast =IF(V$8="Actual",VLOOKUP($B$1&$A9,'New Financials Template.xls'!Database,17,IF(V$8="Forecast",VLOOKU P($B$1&$A9,'New Financials Template.xls'!Database,29,0)))) The word Forecast is in cell V8 and is formatted as text. All of the vlookups work correctly where the word is "Actual", but when it's "Forecast" it returns the value "FALSE" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Threaded Mode
