VLOOKUP Examples 2- categorise, bands
VLOOKUP Ex 8
Why is the VLOOKUP’s in J8 to L8 pulling through information relating to SP010 instead of the correct SP0101?
Before you watch the solution, have a look again at the sort order of column A. Does it make sense to you?
VLOOKUP Ex 9
Create the following spreadsheet with the relevant inputs
In the first yellow block, use a VLOOKUP to determine the interest rate to use.
In the second yellow block calculate the interest earned
To see the full course contents click here.