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
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
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies