Jump to content



Photo

Excel - LOOKUP help

excel formula

  • Please log in to reply
3 replies to this topic

#1 jerzdawg

jerzdawg

    Neowinian

  • Tech Issues Solved: 1
  • Joined: 09-October 02
  • Location: new jersey

Posted 30 July 2013 - 20:52

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.

 

 




#2 +Nik L

Nik L

    Where's my pants?

  • Tech Issues Solved: 2
  • Joined: 14-January 03

Posted 30 July 2013 - 21:07

VLOOKUP is your friend :)



#3 OP jerzdawg

jerzdawg

    Neowinian

  • Tech Issues Solved: 1
  • Joined: 09-October 02
  • Location: new jersey

Posted 30 July 2013 - 21:24

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.



#4 Neo003

Neo003

    Those who believe in telekinetics, raise my hand.

  • Joined: 12-June 03

Posted 30 July 2013 - 21:44

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