Simple internal database query in Excel 2007

[Joseph]

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.

 

[:)]

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]

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