Prev: Convert percentage into margin
Next: Pivot table show all days of a month even if no data
From: T. Valko on 15 Apr 2010 18:14
>=IF(B3="PWRFUT",VLOOKUP(A3,FUT!A1:C20,2,0),VLOOKUP(A3,FX!A1:C20,2,0))

Another way to write that formula:

=VLOOKUP(A3,IF(B3="PWRFUT",FUT!A1:C20,FX!A1:C20),2,0)

--
Biff
Microsoft Excel MVP


"Sarah" <Sarah(a)discussions.microsoft.com> wrote in message
news:67FCBBF0-BC19-4C13-A379-DF085E5B8D25(a)microsoft.com...
> Actually Jacob I adjusted it and it works now. Thanks so much for your
> help.
>
> "Sarah" wrote:
>
>> Hi Jacob - that formula pulls in the date for anything that is PWRFUT,
>> but if
>> B3 does not equal that, then its not looking up on the FX sheet.
>> Everything
>> that isnt PWRFUT is feeding in as N/A
>>
>> "Jacob Skaria" wrote:
>>
>> > Try
>> >
>> > =IF(B3="PWRFUT",VLOOKUP(A3,FUT!A1:C20,2,0),VLOOKUP(A3,FX!A1:C20,2,0))
>> >
>> > --
>> > Jacob (MVP - Excel)
>> >
>> >
>> > "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


First  |  Prev  | 
Pages: 1 2 3
Prev: Convert percentage into margin
Next: Pivot table show all days of a month even if no data