Solved

VLOOKUP Excell 2010

Posted on 2011-10-29
206 Views
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
Question by:perla1962

LVL 43

Accepted Solution

Try this file

vlookup-demo.xls
0

LVL 50

Expert Comment

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

LVL 17

Assisted Solution

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

Change references as required.

See sample result.

0

LVL 50

Expert Comment

ssaqibh, looks like we're the only active Excel experts at the moment :-))
0

LVL 43

Expert Comment

Good day to you, teylyn, or is it already night at your place?
0

Author Closing Comment

I got it Thank you.
0

LVL 50

Expert Comment

ssaqibh, almost midnight. See you around.
0

Featured Post

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.