Excel Basics#

Warning

This page is a work in progress

../../_images/image16.png

Questions#

Problem: Find the Revenue

From the source below can you find the Revenue the specified account?

Table

Solution:

This can be solved with a simple VLOOKUP, the formula to find the answer is given below:

=VLOOKUP(F3,B2:D12,3,FALSE)

Problem: Find the Customer Number

From the source below can you find the Customer Number corresponding to the Account Name?

Table

Solution:

VLOOKUP won’t work as Customer Num is to the LEFT of the Account Name. We need INDEX MATCH 📖Explanation

=INDEX(A2:D12,MATCH(F7,B2:B12),1)

Problem: Total Revenue per Sales Rep

From the source below can you find the total revenue per sales rep?

Table

Solution:

This can be solved with a simple SUMIF. For the first row the answer is given below. It will be similar for other rows. =SUMIF(C3:C12,"="&F11,D3:D12)