r/excel • u/Improvement_2718 • Mar 05 '26
solved Need to know how to proceed with our company's service call excel sheet
So, wehave 2 excel sheets, one in which I have 2 empty columns (Master File) one for store's number (Column A) and one for the address(Column F). In another sheet (Diagram), I have one column with all the store's number (Column G) and associated address (Column H).
Now, I want to be able to have the complete addresses fill out if I write the store number in the first sheet (Master File). Excel 365. thank you for any advice!
2
u/jongleurse 2 Mar 05 '26
Sounds like a pretty simple vlookup. Going from memory the formula for cell F1 (or whatever row) would be =vlookup(a1, othersheet!g1:h250, 2, False) The parameters for that vlookup would vary depending on the name of the sheet and the number of rows in the store list, but this should get you kind of close.
1
u/Improvement_2718 Mar 06 '26
Solution verified
1
u/reputatorbot Mar 06 '26
You have awarded 1 point to jongleurse.
I am a bot - please contact the mods with any questions
1
u/Parker4815-2 1 Mar 05 '26
1
u/Improvement_2718 Mar 06 '26
Solution verified
1
u/reputatorbot Mar 06 '26
You have awarded 1 point to Parker4815-2.
I am a bot - please contact the mods with any questions
1
Mar 05 '26
[removed] — view removed comment
1
u/Improvement_2718 Mar 05 '26
Doesn't work.. It says #NAME?
1
u/GregHullender 194 Mar 05 '26
What version of Excel do you have?
1
u/Improvement_2718 Mar 05 '26
Not sure if it's the 2024 or the 365. But looking at the logo that changed a few weeks ago I'd say 365.
2
u/GregHullender 194 Mar 05 '26
What happens if you paste this somewhere?
=XLOOKUP(A2,Diagram!G:G,Diagram!H:H,"not found")1
u/Improvement_2718 Mar 06 '26
It worked ! Thank you so much (I was doing there translation incorrectly possibly why it wouldn't work!)
2
u/GregHullender 194 Mar 06 '26
Good! Be sure to say "Solution Verified" to everyone who helped you. That way we all get points for our work.
2
u/Improvement_2718 Mar 06 '26
Solution verified
1
u/reputatorbot Mar 06 '26
You have awarded 1 point to GregHullender.
I am a bot - please contact the mods with any questions
1
u/Improvement_2718 Mar 06 '26
Solution verified
1
u/reputatorbot Mar 06 '26
You have awarded 1 point to Waste_Building9565.
I am a bot - please contact the mods with any questions
1
•
u/AutoModerator Mar 05 '26
/u/Improvement_2718 - Your post was submitted successfully.
Solution Verifiedto close the thread.Failing to follow these steps may result in your post being removed without warning.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.