1. ## 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. ## 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. ## Re: Inherrited formula - help to understand please. (Excel 2003)

I had tried and crashed. Trying again.
Thanks

4. ## 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. ## 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.

#### Posting Permissions

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