Help with Vlookup formual--Please!

[Bunderwood75]

Here is my problem---

Qtr 1 Qtr 2 Qtr 3 Qtr 4
WhatYaMaCallIts 10.52% 11.91% 8.54% 5.43%
DoDads 10.55% 10.47% 9.24% 8.82%
Thingies 10.21% 7.42% 9.13% 5.67%

I need a Vlookup formula that will return the correct percentage when you enter a product name and a Qtr.

Example: When I enter DoDads in cell A15 and
Qtr 2 in cell A16 I need the formula to return the value 10.47% in cell A17.

Your help would be greatly appreciated.
Thanks!

 

[Yogi Anand]

On 2002-05-09 14:30, Bunderwood75 wrote:
Here is my problem---

Qtr 1 Qtr 2 Qtr 3 Qtr 4
WhatYaMaCallIts 10.52% 11.91% 8.54% 5.43%
DoDads 10.55% 10.47% 9.24% 8.82%
Thingies 10.21% 7.42% 9.13% 5.67%

I need a Vlookup formula that will return the correct percentage when you enter a product name and a Qtr.

Example: When I enter DoDads in cell A15 and
Qtr 2 in cell A16 I need the formula to return the value 10.47% in cell A17.

Your help would be greatly appreciated.
Thanks!

use
=VLOOKUP("DoDads",A1:E4,MATCH("Qtr 2",A1:E1,0),0)

 

[Aladin Akyurek]

Lets assume that A1:E4 houses the sample data you provided:

{"","Qtr 1","Qtr 2","Qtr 3","Qtr 4";
"WhatYaMaCallIts",0.1052,0.1191,0.0854,0.0543;
"DoDads",0.1055,0.1047,0.0924,0.0882;
"Thingies",0.1021,0.0742,0.0913,0.0567}

Use:

=OFFSET($A$1,MATCH(G1,$A$2:$A$4,0),MATCH(G2,$B$1:$E$1,0))

where G1 contains a value like doDads and G2 a quarter value like Qtr 2.

Aladin
This message was edited by Aladin Akyurek on 2002-05-09 14:41