I am often recommending the Microsoft Excel Blog as a useful resource to intermediate and advanced excel users. They have some good VLOOKUP articles there, that are worth passing on:
- =VLOOKUP (uhh…now what?) – which leads to a 2 page tip sheet in PDF.
- VLOOKUP: No more #N/A – about what to do whit those messy #N/A messages – also leads to a free VLOOKUP on line lesson
- Solutions to Three Common Problems when Using VLOOKUP() – which discusses the “ZOOLANDER problem”.