Sign in to follow this  
Followers 0
jerzdawg

Excel - LOOKUP help

4 posts in this topic

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.

 

 

Share this post


Link to post
Share on other sites

VLOOKUP is your friend :)

1 person likes this

Share this post


Link to post
Share on other sites

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.

1 person likes this

Share this post


Link to post
Share on other sites

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

1 person likes this

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.