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" |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup
You need at least a closing ")" and probably a 0 for the range_lookup on
your first lookup: =IF(V$8="Actual",VLOOKUP($B$1&$A9,'New Financials Template.xls'!Database,17,0),IF(V$8="Forecast",VLO OKUP($B$1&$A9,'New Financials Template.xls'!Database,29,0))) -- Biff Microsoft Excel MVP "Micki" wrote in message ... 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" |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup
Ahhh, missed that. Thank you.
"T. Valko" wrote: You need at least a closing ")" and probably a 0 for the range_lookup on your first lookup: =IF(V$8="Actual",VLOOKUP($B$1&$A9,'New Financials Template.xls'!Database,17,0),IF(V$8="Forecast",VLO OKUP($B$1&$A9,'New Financials Template.xls'!Database,29,0))) -- Biff Microsoft Excel MVP "Micki" wrote in message ... 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" |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup
You're welcome!
-- Biff Microsoft Excel MVP "Micki" wrote in message ... Ahhh, missed that. Thank you. "T. Valko" wrote: You need at least a closing ")" and probably a 0 for the range_lookup on your first lookup: =IF(V$8="Actual",VLOOKUP($B$1&$A9,'New Financials Template.xls'!Database,17,0),IF(V$8="Forecast",VLO OKUP($B$1&$A9,'New Financials Template.xls'!Database,29,0))) -- Biff Microsoft Excel MVP "Micki" wrote in message ... 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" |
Reply |
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 |