Excel Basics

Find Revenue

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

Answer

This can be solved with a simple VLOOKUP

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

Find Customer Number

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

Answer

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

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

Total Revenue

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

Answer

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)

Questions