Vlookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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",VLOOKUP($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"
 
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",VLOOKUP($B$1&$A9,'New
Financials
Template.xls'!Database,29,0)))
 
Ahhh, missed that. Thank you.

T. Valko said:
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",VLOOKUP($B$1&$A9,'New
Financials
Template.xls'!Database,29,0)))
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COMPLICATED FORMULA WITH EMBEDDED HLOOKUP 1
VLOOKUP WITH BLANK REFERENCE CELLS 3
Formula uses previous saved spreadsheet data! 4
formula for multiple variables. 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
isna vlookup #n/a but not false 1
=TODAY() and HLOOKUP - help needed 2
Multiple "IF" statements in a formula 1

Back
Top