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.