Populating Data from another sheet, 2 cells..

[mm107]

Hello Excel world!

Here is my situation:

I am basically "mapping" locations on an excel sheet...

Headers:
Name | Lattitude | Longitude | ZIP code

I have another list of US ZIP Codes, that also have the longitute and latitude data.

What i need is, when a user enters in the zip code information in the last column, to automatically fill in the lattitude and longtitude using the sheet.

 

[VoG]

You should be able to use INDEX and MATCH for that http://www.contextures.com/xlFunctions03.html