Prev: Convert percentage into margin
Next: Pivot table show all days of a month even if no data
From: Sarah on 15 Apr 2010 09:04
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
From: Eduardo on 15 Apr 2010 09:10
Hi,

=if(B3="PWRFUT",lookup(A3,'FUT'!A1:C20,2),lookup(A3,'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
From: Sarah on 15 Apr 2010 09:43
Everything feeds in as #NA with that formula.

"Eduardo" wrote:

> Hi,
>
> =if(B3="PWRFUT",lookup(A3,'FUT'!A1:C20,2),lookup(A3,'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
From: Eduardo on 15 Apr 2010 09:49
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(A3,'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
From: Pecoflyer on 15 Apr 2010 10:05

HOW TO GET FURTHER HELP WITH A WORKBOOK
For further help with it why not join our forums (shown in
the link below). It's completely free. If you do join you will have the
opportunity to add attachments to your posts so you can add workbooks to
better illustrate your problems and get help directly with them. Also if
you do join please post in this thread (link found below) so that people
who have been following or helping with this query can continue to do
so. :)


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?u=14
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=195826

http://www.thecodecage.com/forumz

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