Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need an if statement formula to combine a column on a sheet to acellon another sheet
Solved by T. F. in 44 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 06/08/2018 - 10:07
Excelchat Expert 06/08/2018 - 10:07
Hello, I understand that you need help with an if() statement to combine a column and a cell from another sheet, right?
Excelchat Expert 06/08/2018 - 10:09
Are you there?
User 06/08/2018 - 10:10
yes. i wanted to create a birthday anniversary alert .n a dashboard from a column on another sheet
Excelchat Expert 06/08/2018 - 10:10
Okay, I can help you with this. Before we proceed, this is a reminder that our policy is 1 question per session so for this session we'll be resolving this particular question. We also currently do not support VBA/Macro solutions.
Excelchat Expert 06/08/2018 - 10:11
Do you have a file we can work on so I can have a better understanding of your request?
User 06/08/2018 - 10:12
yes let me send it to you
Excelchat Expert 06/08/2018 - 10:13
Please use the clip icon next to this chat to send the file.
Excelchat Expert 06/08/2018 - 10:17
Hello, I don't mean to rush you but we are slowly running out of time and we may not have enough time to do this if we don't act soon.
Excelchat Expert 06/08/2018 - 10:20
Are you there?
Excelchat Expert 06/08/2018 - 10:23
User 06/08/2018 - 10:23
i tried sending it
Excelchat Expert 06/08/2018 - 10:23
If you are having issues with this chat. Please do not rate poorly. Instead contact our support team to log your complaint.
Excelchat Expert 06/08/2018 - 10:24
Excelchat Expert 06/08/2018 - 10:24
Is the file an Excel file?
User 06/08/2018 - 10:24
User 06/08/2018 - 10:24
ita an excel file
Excelchat Expert 06/08/2018 - 10:25
There are several things that our system won't accept. It won't accept Macro files, it won't accept files that are too large.
Excelchat Expert 06/08/2018 - 10:25
Are you getting an error when attempting to send it?
Excelchat Expert 06/08/2018 - 10:28
Still with me?
User 06/08/2018 - 10:29
i think i should probably send it to the email adress...what do u think
[Uploaded an Excel file]
Excelchat Expert 06/08/2018 - 10:29
There. You were able to send it now.
User 06/08/2018 - 10:29
Excelchat Expert 06/08/2018 - 10:30
Okay, which sheets should I be looking at?
User 06/08/2018 - 10:30
so the birthday dates are in the bio data
Excelchat Expert 06/08/2018 - 10:31
Okay, I can see a column in there that shows the date of the birthday and also a column that says Happy Birthday if the date today is the same as the date in the Birthday column.
User 06/08/2018 - 10:31
i want to create an alert on the dash board to indicate birthday anniversary when even it comes
Excelchat Expert 06/08/2018 - 10:31
Where in the Dashboard/
User 06/08/2018 - 10:32
yesh i want to transfer that to a cell on the dash board
User 06/08/2018 - 10:32
its on the other sheet
Excelchat Expert 06/08/2018 - 10:32
So if there's someone who is celebrating their birthday today, what do you want to see in the Dashboard sheet?
User 06/08/2018 - 10:34
i want to see a message displaying happy bithday and the name of the person including email adress or the persons phone number
Excelchat Expert 06/08/2018 - 10:34
What if there are multiple people celebrating their birthday today?
User 06/08/2018 - 10:35
wow i never thought of that
User 06/08/2018 - 10:35
dats why i need help
Excelchat Expert 06/08/2018 - 10:35
Okay, I'm going to try and work on this with that in mind.
User 06/08/2018 - 10:36
thank will be nice
User 06/08/2018 - 10:36
Excelchat Expert 06/08/2018 - 10:41
I'm going to leave the formatting to you but I'll have a functional formula in here.
User 06/08/2018 - 10:41
Excelchat Expert 06/08/2018 - 10:42
Please download this file.
[Uploaded an Excel file]
Excelchat Expert 06/08/2018 - 10:42
Let me know once you've downloaded it.
User 06/08/2018 - 10:42
i have downloaded it
Excelchat Expert 06/08/2018 - 10:43
Okay, in the Dashboard you will see the same Yellow bar you had.
Excelchat Expert 06/08/2018 - 10:43
That bar will light up Happy Birthday if there is at least one person celebrating their birthday today.
Excelchat Expert 06/08/2018 - 10:43
The name of the person and the details are in the rows below.
Excelchat Expert 06/08/2018 - 10:43
If there are multiple celebrants then it will list them all in several rows.
User 06/08/2018 - 10:45
wow thank you very much
Excelchat Expert 06/08/2018 - 10:45
Glad to have helped!
Excelchat Expert 06/08/2018 - 10:45
The formulas used are array formulas so they need to be confirmed by using CTRL+SHIFT+ENTER instead of just ENTER. You'll know that you've done it correct if the formula gets automatically enclosed in { }
Excelchat Expert 06/08/2018 - 10:45
Would there be anything else that I can help you with regards to the original question?
User 06/08/2018 - 10:46
am greateful....
User 06/08/2018 - 10:46
User 06/08/2018 - 10:48
would it be possible to link the slicers to the drop downs under the Tithes and Special Offerings on the dashboard?
Excelchat Expert 06/08/2018 - 10:49
Oh we can help you with that but since we have a very strict policy of 1 question per session, I'll have to ask you to post this as a new question so a Slicers experts can help you with it.
User 06/08/2018 - 10:50
Alright sir
Excelchat Expert 06/08/2018 - 10:50
Alright, if you have no other questions regarding the original concern, I'd appreciate a 5-star rating and your feedback if you think I deserve it.
Excelchat Expert 06/08/2018 - 10:50
I'll be giving you high ratings as well so the other experts will know that you are a good client and should be taken care of.
Excelchat Expert 06/08/2018 - 10:50
Please do not forget to click the End Session button otherwise I'll be stuck here until the timer expires and be unable to help others. Thank you.
User 06/08/2018 - 10:50
You have done Alot for me
User 06/08/2018 - 10:51
thank you

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc