Alter 15)

15) Complex Data Fill In (VLOOKUP on Steroids)

I refer to this function as the VLOOKUP on Steroids because it can do several things that you would not get with just a vlookup.

First of all, it can look to the left and to the right of the value you find, not just to the right.

Second, it will tell me, through the use of color coding, if I have more than one corresponding return value from the lookup array. It will also tell me when my target value is different from my LOOKUP value.

Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc