if statement

I need to have a formula changed in sheet  5620-Rhealth & 5640-Retire (the formulas that need tobe chaged start at g6.  they need to include the monthly figures in sheet 5390-Stipend for the 3 employees listed in this sheet.
In other words cells g6:ag29 in sheet 5620 represent the amount of dollars we have to spend in retirements cost based on an employees salary, the 3 in sheet 5390 receive an additional stipend that must also be factored into this retirement cost calculation.
expert.xlsx
wcodyInformation Systems SpecialistAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

csoussanCommented:
I'm not sure I fully understood your request but take a look at the attached and let me know if it works for you.  

Hope it helps!
expert.xlsx
csoussanCommented:
Hi wcody,

Any update on your issue?
wcodyInformation Systems SpecialistAuthor Commented:
This doesn't appear to be the solution.

Basically I want sheet 5620 & 5640 to include any salary amount from 5390 in their existing calculation.  They are simply mulitplying the salaries from sheet 5100 right now and they need to include the additional salaries listed in sheet 5390.
wcodyInformation Systems SpecialistAuthor Commented:
To further clarify shet 5620 cell G8 should be sheet 5100 e8+sheet 539e6* sheet 5620f8
csoussanCommented:
I've attached a new file.  The revised formula is as follows:

=(IFERROR(VLOOKUP($B6,'5100-Salaries'!$B$6:$AE$29,COLUMN(G$1)-3,FALSE),0)+IFERROR(VLOOKUP($B6,'5390-Stipend'!$B$6:$AF$8,COLUMN(G$1)-3,FALSE),0))*$F6

My formula adds the values from '5100-Salaries' to 5390-Stipend where the ID Numbers in column B match and multiples that number by the value in column F.

I made the following assumptions:

1) '5100-Salaries' and '5390-Stipend' together before multiple the result by column F.
2) You want all columns multipled by column F.

Let me know if that works. :)
expert.xlsx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.