Home

Excel spreadsheets

%3CLINGO-SUB%20id%3D%22lingo-sub-741149%22%20slang%3D%22en-US%22%3EExcel%20spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-741149%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spreadsheet%20with%20a%20list%20of%20club%20members%20data%20Names%2C%20address%20phone%20etc.%3C%2FP%3E%3CP%3ECan%20I%20easily%20have%20a%20couple%20of%20those%20details%20automatically%20transfer%20to%20another%20sheet%20and%20remain%20constant%20even%20if%20main%20sheet%20is%20resorted%20by%20different%20category%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-741149%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-741356%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20spreadsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-741356%22%20slang%3D%22en-US%22%3EYes%2C%20you%20can%20do%20that%20by%20VLOOKUP%20or%20INDEX-MATCH.%3C%2FLINGO-BODY%3E
Highlighted
newqlder1944
Occasional Visitor

I have a spreadsheet with a list of club members data Names, address phone etc.

Can I easily have a couple of those details automatically transfer to another sheet and remain constant even if main sheet is resorted by different category?

1 Reply
Yes, you can do that by VLOOKUP or INDEX-MATCH.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies