Hi,
I'm looking for a formula to copy data from a cell based on what it finds on another cell in the same row.
For example I have 2 sheets. One sheet has names and email addresses. the other sheet has names and their attendance to an event. However, the second sheet has additional names that are not in the first sheet so I can't do a simple sort and copy/paste.
How can I insert the appropriate email address matched with the name in the first sheet? (for ex, it needs to search the second sheet to find the same first name last name fields, then export/copy the email address from the next column into the first sheet in the column or cell i designate)
Please help ASAP!
Thanks!
Bookmarks