Do you want data from B C and D all in one cell (separated by
commas?), or in 3 different cells?

Which cell is the zip code that you are looking up located?

Pete

On Aug 5, 4:50*pm, Jack wrote:
I need to to create a vlookup that looks up within a table - first a zip code
(column a) and then a city within that zip code (column b) and returns me
columns b, c, & d.