What is the formula for;
If a text is entered into a cell, it matches a text in column A and a YES in column K?
Thank you!
What is the formula for;
If a text is entered into a cell, it matches a text in column A and a YES in column K?
Thank you!
Last edited by Pepe Le Mokko; 03-15-2020 at 04:16 AM. Reason: Title
Formula in Column C. Data entered in Column B matches Column A .
=if(And(A1= B1,K1="Yes"),"Match", "No Match")
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
In future, please make your title more informative - almost everyone wants help with a formula!
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.
Wow. Such a quick response. Thank you so much for your help. Ali, this is my first time on the forum. Based on my question, how would you make the title more informative or specific, so that i know for next time. Thanks, again!
If you edit the original post (click on Edit just below the post), you can change the question and/or add a Prefix of "Solved". If Solved then we don't try to solve it again as someone else has. That helps us not waste time for others.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks