Hi there, how do I make my sheet do this -> if cell c3 = yes add email address from cell A2 to another sheet
Hi there, how do I make my sheet do this -> if cell c3 = yes add email address from cell A2 to another sheet
Example: In sheet2, =if(sheet1!C2="YES",sheet1!A2,"Whatever you like")
Click the * to say thanks.
Great that worked. I'm also trying to do this and would love some help If h2 = yes put the email from e2 into j2
In J2:
=IF(H2="yes",E2,"")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you both. I am now having a small problem with the following. =if(Sheet2!H2="YES",Sheet2!E2,"") <-- This formula worked on the first row but did not pull the data from any other rows
Just drag the formula down and it will increment. If you don't want H2 to increment, then put a dollar sign between the H and 2 to fix the row reference.
It works when I drag the formula down however I have to drag the formula down after every entry on sheet 2 before I can see it in sheet 1. Any ideas why?
Check you calculations to be set to automatic. Also, it will return blanks if you don't have data in E2 or H2 is not yes on Sheet2
Attach the workbook if you want any further help with this, otherwise we can only guess.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks