Excel Basics

Questions
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 📖Explanation​
=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)
Last modified 1mo ago