Prev: How do I set NETWORKDAYS to regard friday and saturday as week
Next: changing formula
From: Sarah on 13 Apr 2010 12:17
I am trying to lookup 2 separate ranges based on the IF statement.

For example If B3="PWR-PHYS" then I need it to lookup(A3,'DatePivot'!A1:B20,2)
But if B3 does not = "PWR-PHYS", then i need it to
lookup(A3,'Location'!A1:B20,2)

So whether it equals pwr-phys or doesnt, I need a value returned from
separate locations. Please advise how I can do this
From: Glenn on 13 Apr 2010 12:23
Sarah wrote:
> I am trying to lookup 2 separate ranges based on the IF statement.
>
> For example If B3="PWR-PHYS" then I need it to lookup(A3,'DatePivot'!A1:B20,2)
> But if B3 does not = "PWR-PHYS", then i need it to
> lookup(A3,'Location'!A1:B20,2)
>
> So whether it equals pwr-phys or doesnt, I need a value returned from
> separate locations. Please advise how I can do this


=VLOOKUP(A3,IF(B3="PWR-PHYS",'DatePivot'!A1:B20,'Location'!A1:B20),2)
From: Gary Brown on 13 Apr 2010 12:38
=if(B3="PWR-PHYS",lookup(A3,'DatePivot'!A1:B20,2),lookup(A3,'Location'!A1:B20,2))
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Sarah" wrote:

> I am trying to lookup 2 separate ranges based on the IF statement.
>
> For example If B3="PWR-PHYS" then I need it to lookup(A3,'DatePivot'!A1:B20,2)
> But if B3 does not = "PWR-PHYS", then i need it to
> lookup(A3,'Location'!A1:B20,2)
>
> So whether it equals pwr-phys or doesnt, I need a value returned from
> separate locations. Please advise how I can do this
From: Mitch on 16 Apr 2010 15:13
Try this and click yes if this works.

=IF(B3="PWR-PHYS",Vlookup(A3,'DatePivot'!A1:B20,2),vlookup(A3,'Location'!A1:B20,2))


"Glenn" wrote:

> Sarah wrote:
> > I am trying to lookup 2 separate ranges based on the IF statement.
> >
> > For example If B3="PWR-PHYS" then I need it to lookup(A3,'DatePivot'!A1:B20,2)
> > But if B3 does not = "PWR-PHYS", then i need it to
> > lookup(A3,'Location'!A1:B20,2)
> >
> > So whether it equals pwr-phys or doesnt, I need a value returned from
> > separate locations. Please advise how I can do this
>
>
> =VLOOKUP(A3,IF(B3="PWR-PHYS",'DatePivot'!A1:B20,'Location'!A1:B20),2)
> .
>
 | 
Pages: 1
Prev: How do I set NETWORKDAYS to regard friday and saturday as week
Next: changing formula