Ok so below is my main information on my summary spreadsheet and the due date
column is where I need the formula to pull in.

deal_num Instrument Type Due Date
20732 PWR-EXCH-FUT 9/29/2009
20733 PWR-EXCH-FUT 10/7/2009
20734 PWR-EXCH-FUT 7/2/2009
21607 PWR-PHYS 7/20/2010
21608 PWR-PHYS 7/20/2010


Here is the information from the Futures spreadsheet, so If the instrument
type from above is equal to PWR-EXCH-FUT, then lookup the associated deal
number on the Futures spreadsheet and pull the event date into due date
column above

deal_tracking_num event_date
20732 9/29/2009
20733 10/7/2009
20734 7/2/2009
20735 7/2/2009
20736 7/6/2009

And here is the information from the FX spreadsheet for the 2nd vlookup, so
If the instrument type from above is not equal to PWR-EXCH-FUT, then lookup
the associated deal number in the FX spreadsheet and pull the event date into
due date column above

deal_tracking_num event_date
21589 1/20/2011
21607 7/20/2010
21608 7/20/2010
21609 7/20/2010
21618 1/20/2011
21619 1/20/2011

"Eduardo" wrote:

Hi,
could you post an example of your data and the results you are looking for,
thanks

"Sarah" wrote:

Everything feeds in as #NA with that formula.

"Eduardo" wrote:

Hi,

=if(B3="PWRFUT",lookup(A3,'FUT'!A1:C20,2),lookup(A 3,'FX'!A1:C20,2))

"Sarah" wrote:

Hi All,

I am looking to use an if statement with 2 separate vlookups. Is this
possible? Basically what I want to do is if B3=PWRFUT then
lookup(A3,'FUT'!A1:C20,2)
However, if B3 does not equal PWRFUT then lookup(A3,'FX'!A1:C20,2)

Please help - thanks