• 0

Excel - LOOKUP help


Question

As always I come to my Excel experts for help.

 

Sheet1 will have a list of 400+ "codes" (which are 5 digit #s store as zip code format so the 0 shows if thats how the # starts).

 

Code will be in B3, B4, etc. 

 

F3, G3, H3, I3 will have missing info that I would like "looked up"

 

Sheet 2 has all info needed

 

a3 has the code, e3, f3, g3 has the information required in this case its address, city, state, zip

 

Is there a way to lookup this information and have it pulled into sheet 1 when the code is entered. 

 

Thanks in advance.

 

 

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

VLOOKUP is your friend :)

hmm.. havent used that one at all.. can you elaborate?

 

Ok - I came up with this...

 

=VLOOKUP(B3, Sheet2!$A$3:$H$113, 6, FALSE)

 

and its pulling the CITY field correctly.  But when I copy and paste it into the address or state field (change the 6 to a 5 or 7) I get the #N/A error.  Why can it find the city but nothing else?

 

OK, dumb mistake, didnt change the B to absolute.  Everything is working now.

  • Like 1
Link to comment
Share on other sites

This topic is now closed to further replies.