Simple internal database query in Excel 2007
 

Hi and thanks. I am ignorant about databases and am grateful for your help.
I have a excel workbook for an alumni club I volunteer for. On one sheet I
have email addresses with a column for "lastname". On another sheet in the
same workbook, I have a list of people who have paid dues (and those who have
not) also with a "lastname" column. I want to perform a query so that I can
get all of the email addresses on the sheet next to dues payers (so I can
send a "thank you") and non payers (so I can send a reminder). It will take
hours to do it manually. Can you help me? Thanks so much! Blessings.

Simple internal database query in Excel 2007
 

See how is this. Assuming that sheet 1 is the database of the people in the
club with Column A "lastname" and Column B "email"

In sheet 2, Column A (dues payers) - "lastname", Column B - email
under email in B2, paste this =INDEX(Sheet1!B:B,MATCH(A2,Sheet1!A:A,0)) and
drag down...

for non payers, do the same, just change A2 to the relevant cell


"Joseph" wrote:

Hi and thanks. I am ignorant about databases and am grateful for your help.
I have a excel workbook for an alumni club I volunteer for. On one sheet I
have email addresses with a column for "lastname". On another sheet in the
same workbook, I have a list of people who have paid dues (and those who have
not) also with a "lastname" column. I want to perform a query so that I can
get all of the email addresses on the sheet next to dues payers (so I can
send a "thank you") and non payers (so I can send a reminder). It will take
hours to do it manually. Can you help me? Thanks so much! Blessings.

Simple internal database query in Excel 2007
 

Thank you so much!! That did it!! You are awesome!!!

"Joseph" wrote:

Hi and thanks. I am ignorant about databases and am grateful for your help.
I have a excel workbook for an alumni club I volunteer for. On one sheet I
have email addresses with a column for "lastname". On another sheet in the
same workbook, I have a list of people who have paid dues (and those who have
not) also with a "lastname" column. I want to perform a query so that I can
get all of the email addresses on the sheet next to dues payers (so I can
send a "thank you") and non payers (so I can send a reminder). It will take
hours to do it manually. Can you help me? Thanks so much! Blessings.