Thanks:  0
Likes:  0

1. Here is my problem---

Qtr 1 Qtr 2 Qtr 3 Qtr 4
WhatYaMaCallIts 10.52% 11.91% 8.54% 5.43%
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!

2. 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%
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

3. 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;
"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.

[ This Message was edited by: Aladin Akyurek on 2002-05-09 14:41 ]

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•