Lookup to the left instead of right (like VLOOKUP)
- In C8 column we want to create a lookup to find how much the student (represented by student number in column A) owes us.
- The table we need to use (H8 to I35) shows the student number to the right of the amount (so we cannot use VLOOKUP)
- Use a MATCH/ INDEX combination to pull through this data to the left of the lookup value.
To see the full course contents click here.