1.Not locking the table when copying the formula to other cells

As you copy and paste any formula, it will automatically adjust the formulas so that their relative position to the cell with the formula stays the same

2.Using “true” rather than “false” for the estimator

3.When there are multiple identical entries in the source table

If the table you are searching in contains multiple identical entries, VLOOKUP will only report the data for the first entry

To avoid this, sort data and check for multiple entries before doing a VLOOKUP

1 – Does everyone know what “locking” a cell means?

Basically need to add the $ in front of the column and row to make sure that when you copy and paste, the references don’t move

2 – Always use False if you want to look up the exact value

3 – Issues arise if there are two of the same lookup values. For example, if we had two Bank of Kigali entries in our example.

Need to sort through the data and ensure there aren’t duplicates.

You can automatically search and eliminate duplicate entries by using the Data > Remove Duplicates function.