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"

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"

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"

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"