Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Inherrited formula - help to understand please. (Excel 2003)

    Please, help me with this formula I have inherrited.
    I have Excel file with few WKsheets.
    One WKSheet 'RegData' has data:

    A B C
    1 AA 1 5
    2 BB 4 11
    3 CC 5 5

    It is a sample. Just for demo purposes how data looks.
    Real Range is ='RegData'!A1:F12
    Wsheets names are AA, BB and CC.

    Wksheets have a cell with formula:
    =(((VLOOKUP(LEFT(LB,3),'RegData'!A3:C14,2,FALSE)+( VLOOKUP(LEFT(LB,3),'RegData'!A3:C14,3,FALSE)))*12/TEXT(date,"m")))/SUM(C11:C13)

    On every WKsheet except 2 it calculated result - not on 2.
    I am trying to understand what does this formula does.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Inherrited formula - help to understand please. (Excel 2003)

    What is LB? A named range?

    It would be easier to help you if you posted a copy of the workbook with dummy data.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Inherrited formula - help to understand please. (Excel 2003)

    I had tried and crashed. Trying again.
    Thanks
    Attached Files Attached Files

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Inherrited formula - help to understand please. (Excel 2003)

    I don't see anything resembling the formula from your first post in the workbook, so I don't have the slightest idea what I should do with it.

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Inherrited formula - help to understand please. (Excel 2003)

    As far as I can see from your formula, it looks up a value in a table and adds up the corresponding values in columns B and C of that table, then scales that up to an annual estimate and expresses it as a fraction of the total of C11:C13. Without seeing it with some data, I can't say any more than that.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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