Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Help with Vlookup formual--Please!

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!



  2. #2
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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)

    Regards!

    Yogi Anand, D.Eng, P.E.
    Energy Efficient Building Network LLC
    www.energyefficientbuild.com

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,030
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    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 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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