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!
Bookmarks