Sorting a list of people by reference to another list

ScottA · #1 06-08-2014, 04:10 AM

D -

If you already have a worksheet with the data for the clubs and districts that data doesn't have to be in with the same worksheet as the data for your members.

Note this example. The district info is on sheet 2.
And now the formula changes to

=VLOOKUP(G2,Sheet2!$A$2:$B$11,2,0)

Darkiness · #2 06-08-2014, 04:20 AM

ScottA and whatsup - I am very grateful to you both for pushing me to end point and then for getting me there.

I can't tell you how much you have helped me.
Thank you very much, indeed

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to import list from Excel into drop-down list into word	ahw	Word VBA	43	02-28-2020 08:11 PM
List Style Numbering picks up out of order number from LATER list	spthomas	Word	12	12-16-2013 05:23 PM
Creating a list and sorting alphabetically.	irvsax	Word	4	09-04-2013 11:47 PM
Sorting numerically in recipient list	greengauge	Mail Merge	2	05-19-2013 09:58 AM
Need to delete 'field code changed' in my reference list	leb	Word	4	05-04-2013 12:25 AM