[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 258
  • Last Modified:

VLOOKUP Excell 2010

Hi,
Can you guys help me out I’m lost somewhere  I’m already completed the table; I just need to display the sum of the salary and the bonus, and add the formula on cell C21



 C20       Name      Code      Check Amount
C21       Mary          1      
C22        Sue           3      
C23        Ralph         2      

TOTAL              $                 -  


Table to Compute Sum of Salary and Bonus:
Code      Salary                    Bonus      
1            10,000                         500       
2             5,000                         600       
3             8,000                         400       


I’m trying to use the following functions.
=SUM() + SUM()
=VLOOKUP() + VLOOKUP()

0
perla1962
Asked:
perla1962
2 Solutions
 
Saqib Husain, SyedEngineerCommented:
Try this file


vlookup-demo.xls
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

can you explain what you want to sum or lookup? Can you post a sample file? That would make it much clearer.

cheers, teylyn
0
 
LesterClaytonCommented:
Would this help you?

=VLOOKUP(B15,$A$3:$C$5,2)+VLOOKUP(B15,$A$3:$C$5,3)

Open in new window


Change references as required.

See sample result.

 Formula Example
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
ssaqibh, looks like we're the only active Excel experts at the moment :-))
0
 
Saqib Husain, SyedEngineerCommented:
Good day to you, teylyn, or is it already night at your place?
0
 
perla1962Author Commented:
I got it Thank you.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
ssaqibh, almost midnight. See you around.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now