I need to better understand VLOOKUP. I need to map two tables which have
matching zip codes but one does not has less due to less data. Is there a
way to do what the link below does? Basically I am a sumproduct guy happy to
get the total data that comes from what I ask. Now I need text information
from the shorter table that matches numerical data from the larger table.

http://www.ablebits.com/excel-lookup-tables/index.php