VLOOKUP Examples 2- categorise, bands

Please purchase the course before starting the lesson.

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.

Lesson tags: vlookup
Back to: Advanced Excel Course > Key Lookup Functions