-
Recently Browsing 0 members
- No registered users viewing this page.
-
Similar Content
-
- 0 replies
- 3 views
-
Microsoft's Excel web app can now export sheets in the CSV file format
By John Callaham,
- 8 replies
- 3 views
-
- 0 replies
- 2 views
-
Save 75% on Complete Microsoft Excel Course Including How to Program in Excel
By News Staff,
- neowin deals
- deal
- (and 3 more)
- 0 replies
- 3 views
-
- 0 replies
- 2 views
-
Question
jerzdawg
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