match email addresses across two sheets and return value from one sheet to the other

I'm sure this is easy...but not quite getting it!
I have two sheets in a file. 'attendees' and 'products'

Attendees:
Name/Email (all attendees)

Product:
Name/email/parking/evening (only those attendees who bought parking or evening tickets : parking and evening is a number of tickets)

the product sheet is a list of those who bought parking and evening tickets.

I want to add two new columns to 'attendees' that will show their parking and evening tickets having looked it in the product sheet.

thanks!

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Having been three days without a proposed solution, it may be helpful to upload a sample spreadsheet that shows the layout of the data on the product sheet and the expected results (typed manually) based on the data on the attendee's sheet.
To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down toManage Attachments to open the upload window.
Let us know if you have any questions.

Originally Posted by theobrandt

thanks Ali- I'm hoping that new subject is clearer?

theobrandt if you are not aware of it merely editing a post does not change its position in the queue. If after complying with Moderators instructions and after 24 or more hours of no responses, simply add a new post to your own thread with the work "bump". That will put your thread a the top of the What's New list.