-
Recently Browsing 0 members
- No registered users viewing this page.
-
Similar Content
-
Microsoft 365 Roadmap Weekly: Designer is coming to Word and more
By John Callaham,
- microsoft
- microsoft 365
- (and 7 more)
- 0 replies
- 4 views
-
Microsoft 365 Roadmap Weekly: New Copilot features are coming to Word, Excel and more
By John Callaham,
- microsoft
- microsoft 365
- (and 5 more)
- 1 reply
- 4 views
-
Microsoft Excel on the web users can now share links to existing or new Sheet views
By John Callaham,
- 1 reply
- 2 views
-
Microsoft 365 Insiders can preview Check Performance in the Excel Windows app
By John Callaham,
- microsoft
- microsoft 365
- (and 3 more)
- 1 reply
- 1 view
-
The Microsoft Teams Shifts app gets some improvements for importing schedules from Excel
By John Callaham,
- microsoft
- microsoft teams
- (and 5 more)
- 0 replies
- 1 view
-
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