Find Multiple Matching Values in Excel and Highlight - Match & Highlight Names from Two Sheets

Hi, that's really helpful. what is the screen recording software please? . Watching from Germany

Is there a way highlight only the rows that have multiple matching values from another workbook or worksheet?

thanks just followed most of your steps saved hours of time

It didnt work for me when trying to writte it down but if I used the function button it was all good, thanks!

Trying to pull a value from a column on one worksheet that contains two different plan types (for employee benefits) to another worksheet. Example: Column Header = Plan, Text values in that column = Medical or Dental. Wanting the formula to pull in one value if it's Medical and another value if it's Dental to the other worksheet.

Thank you!

I have 2 sheets, tho sheets data's are same but column are interchange (ab to ba) how can I find entire row at single time.....?

You are my hero. THANK YOU for this video.

How do vlookup formula in excel
A1=P b1=D C1=as D1=cd
A2=as b2=cd
Result E1 CELL IN TRUE

C1 AND D1 cell same value match in column A & B

This saved my sanity. Extremely clear directions. Thanks!

The formula is not working I can't highlight the entire raw just the cell. Someone knows why???😅😅😅

madam If i want to merge two large excel sheet into employee.xls, vlookup with other xls having some data, my concern is that how to merge two large scale of excel

Thanks Sharon That was great. Is possible to pull through data from the row on the small list, where it has a match in the big list, and display that data, perhaps where you currently have true/false, or alternitively in a column created next to it for the purpose of displaying "the pulled-though" data ? Thanks again.

Life Saver. Thank you.🤩

You are brilliant Sharon! Easy to understand and exactly what i need! Lifesaver!

I love the way you explain and show your screen. Thank you for taking the time to make these videos!!!!

Instead of this lengthy Conditional Formatting rule:
=SEARCH("TRUE", $A2&$B2&$C2&$D2&$E2&$F2&$G2)
a better option is this:
=FIND("TRUE",$B2:$G2)

Thank you so much

Great video. I would like it normally, but this like for for the shoutout to Pierre Despereaux.

THANK YOU FOR THIS!!!

Ive created a form in a table in word mac and im trying to lock the text so the form user cant edit it, Eg ive put in "client name" and what the user to insert name. But when i lock the text in developer it locks the whole document not allowing me to type the name in text box. Also the developer is only giving me limited legacy tools.can you help me?

This was extremely helpful!! Thank you!

Your video very useful for me ma'am...

Thank you

Love from India

Very informative and easy step by step video.
Thanks