Results 1 to 5 of 5

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

Threaded View

  1. #1
    Registered User
    Join Date
    01-13-2016
    Location
    Auckland, NZ
    MS-Off Ver
    2013
    Posts
    14

    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!
    Last edited by theobrandt; 08-25-2019 at 05:38 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Vlookup plus Hlookup
    By ASPERO in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-26-2011, 09:12 PM
  2. vlookup and hlookup
    By slin in forum Excel General
    Replies: 2
    Last Post: 02-22-2011, 01:33 PM
  3. Vlookup/Hlookup
    By kryt0n in forum Excel General
    Replies: 8
    Last Post: 06-21-2010, 09:34 AM
  4. hlookup/vlookup
    By Sirishgreen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-29-2007, 10:47 AM
  5. HLOOKUP, VLOOKUP
    By heydean in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2006, 04:56 PM
  6. [SOLVED] Vlookup and Hlookup
    By Phlogiston2312 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-20-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1