Hi there,
I have a long list of people's email addresses that I sent out an invitation to and another list with the email addresses that I got a reply from.
In the matching rows and a new column of the former sheet I would like to indicate all the people from the latter list - the fact that these replied - with the word "YES".
I was trying to use VLOOKUP for that but apparently I do not understand this function and whether this is the one to be used in this case?
Please please help!
yes that should work - but you would need an IF to change the result to Yes or No - if the vlookup() cannot find the email - then it will report #N/A
But you could use a countif
in the sheet & cell you want to mark with a yes
Assuming this is B2 on say sheet1
and the original list is in Sheet 2 and the emails are in Column A
=IF( countif( sheet2!A:A, Sheet1!B2) >0 , "Yes", "No" )
if you post a sample sheet - how your data is setup - then we can setup for yo u
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi Etaf,
I attached the sample workbook and would be thrilled if you could set the formula up for me.
Just to clarify, for the people (email addresses) who replied (Column A in the REPLIED sheet), in the ALL INVITES sheet I would like column E to change from NO to YES, providing that has not been done earlier.
Many thanks for your help.
Delete all No's from column E then
in E2 copy paste below and drag down
Formula:
Please Login or Register to view this content.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
use
=IF(COUNTIF(REPLIED!A:A,A2)>0,"Yes","No")
see attached
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks