Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    114
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Is there an alternate for multiple embedded if statements

    Hi There,

    I am developing a spreadsheet where I have equations that I would like to refer to cost value out of a matrix (refer to the attached spreadsheet) based on the competency/skill (Skill1, Skill2...) and the level of the person (L1, L2, L3, L4). I know I could do it with multiple IF statements.

    I was wondering if there is a way to refer into the (with Skill and Level) matrix rather than having multiple if statements.

    Thanks
    Attached Files Attached Files

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 481 Times in 458 Posts
    Hi

    You can use a combination of Offset and Match to do what you want.
    see attached file

    zeddy
    Attached Files Attached Files

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    Also, with your layout a hlookup would work well.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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