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
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)
