Hi guys,
I need to transfer the data from particular cells to different sheet. What I mean by that is:
In sheet1 I have
Name1 LastName1 Email1
Name2 LastName2 Email2
Name3 LastName3 Email3
Name4 LastName4 Email4
In sheet2 I don't have emails and also I have less names, since I need the certain ones:
Name2 LastName2
Name4 LastName4
So the question is, how can I add emails from sheet1 to sheet2 only for specific names?
Thank you so much for any help!
Sheet 2, C1:
=LOOKUP(2,1/((Sheet1!$A$1:$A$4=A1)*(Sheet1!$B$1:$B$4=B2)),Sheet1!$C$1:$C$4)
and copy down
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Please see attache file.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Or this in C2 on Sheet2 of Alkey's sheet.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Thanks to everyone. All done!
Thanks for the feedback Верка!
Good to know that. Thanks for the feedback.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks