Dear Mrs. Sharon, You did to me huge favor by teaching us new ways, I was searching one by one now I do it in 10 seconds, "THANK YOU" not enough but THANK YOU from by bottom of my heart ❤
Oh, thank you so very much for this generous Super Thanks donation to my Channel! I can't tell you how much I appreciate it. I am so very glad that you found my video helpful and that you are now able to save valuable time in your work! Your donation goes towards me being able to create more helpful content, so it is much appreciated. I wish you all the very best. Thank you! ❤️❤️
Wow this just saved me during a data analysis project! OMG. I had watched a couple of other videos but unfortunately couldn't understand them, so yours was perfect. Thank you.
This video was exactly what I need I watched multiple others and they got me close but I couldn't highlight them first video to actually fully help me.
Great tutorial. I normally use Countif instead of match. For the conditional formatting instead of entering "....$A2&$B2..." i would enter "....$A2:$G2" so that the whole range is selected. But great content!
This is very useful! Thank you very much. Tell me please, is there a way I can export my highlighted (matched rows) to a third spreadsheet? Many thanks in advance.
This tutorial I'm sure can assist me in a project I'm looking at. Can I send an Excel workbook to you and describe what I'd like to achieve from the numbers in the workbook. You don't know it but you may well be solving an issue in the Rail and Maritime Industry..
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.
Hi Sharon! I have a master list of data consisting alpha numeric values in Column A in a specific order, In column B some of the values are the same but in a different order. How do I get the matches to be side by side?
That is a feature in Windows 11. You should see that option when you hover over the minimize button if you are on Windows 11. Hope this helps! Thanks for watching!
I use when the data is very huge and if you want to find mathicng values and also identify which cell it is matching use this formula: =IFERROR("B is Present in A" & MATCH(B2, A:A, 0), "B is Absent in A")
Hi. I a number that I need to find in a column. which is clubbed amount of 2 numbers or more in another table. How I can find that numbers? Like I want to find what numbers are adding up to make $3000. is there any way?
Hi Sharon, have a query could you pl help? I have a list of employees like first name, middle name and last name in one file and in another file the names are in some different pattern. Can i find the most close match names?
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?
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.
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
How to I lookup value, if my lookup array is scattered all from A1 to Z50 (multiple rows and columns)? I have unique ID in one row in one sheet, and same or different IDs scattered from A1 to Z50 in sheet 2 i have to search and lookup if data matchs from sheet1 to sheet 2, how do i lookup in multiple rows and columns??
Mam, how to change multiple different numbers in multiple cells into one unique number for e.g. change 1,2,3,4,5.......into any unique no. suppose into 99.
This was helpful but now I’m trying to figure out how to match the data from One column to the next couple of columns over and have it highlight the exact match
My formula keeps changing cells down by one for sheet 2 so I'm not getting the correct answers. Nothing of any videos I've watched is helping....frustrating the crap outta me and supposed to be so easy to do
It seems like you want to use the VLOOKUP formula in Excel to compare the values in cells C1 and D1, and if they match a pair of values in columns A and B, you want to display the corresponding result in E1. Here's how you can do that: Assuming your data is in columns A, B, C, and D, and you want to check if the value in C1 matches a value in column A and the value in D1 matches a value in column B, and then display the corresponding result from column E in cell E1, you can use the following formula in cell E1: =IF(AND(C1"", D1""), IFERROR(VLOOKUP(C1&D1, A:B, 2, FALSE), ""), "") It seems like you want to use the VLOOKUP formula in Excel to compare the values in cells C1 and D1, and if they match a pair of values in columns A and B, you want to display the corresponding result in E1. Here's how you can do that: Assuming your data is in columns A, B, C, and D, and you want to check if the value in C1 matches a value in column A and the value in D1 matches a value in column B, and then display the corresponding result from column E in cell E1, you can use the following formula in cell E1: excel Copy code =IF(AND(C1"", D1""), IFERROR(VLOOKUP(C1&D1, A:B, 2, FALSE), ""), "") Let's break down the formula: AND(C1"", D1""): This part checks if both cells C1 and D1 are not empty. IFERROR(VLOOKUP(C1&D1, A:B, 2, FALSE), ""): If both C1 and D1 are not empty, this part combines the values in C1 and D1 using &, creating a lookup value. It then performs a VLOOKUP in columns A and B using the combined value as the lookup value. The 2 specifies that we want to retrieve the value from the second column (B) of the range A:B. The FALSE argument ensures an exact match. If there's an error (meaning no match was found), it returns an empty string (""). The outermost IF() checks if both C1 and D1 are not empty. If they are empty, it returns an empty string. So, if the values in C1 and D1 match a pair of values in columns A and B, the corresponding value from column E will be displayed in cell E1. If there's no match or if C1 or D1 is empty, cell E1 will be empty. You can drag the formula down in column E to apply it to other rows if needed. Just remember that this formula is case-sensitive, so make sure the values in columns A, B, C, and D match exactly. Hope this helps! Thanks for watching!
Do you know that you are amazing and gorgeous in beauty, I have a question is there a function or code to compare two cells for a percentage, whether it is text or Numbers.
Not sure if you monitor this video for comments but I can’t find any instructional videos for comparing two columns to find a matching name IN A TEXT STRING. Ie one cell may be Mr. John smith in one column and John Smith , Mr. in the second column. I want to be able to match the name Smith. Thank you. I do find your explanation easy to understand so I’m hoping you have a simple solution
Tina Fey you rock! SNL, and now Excel help online. Honestly though this really helped me thank you!
Haha! I get that all the time 😂 I'm glad you found it helpful! Thanks for watching!
Dear Mrs. Sharon,
You did to me huge favor by teaching us new ways, I was searching one by one now I do it in 10 seconds, "THANK YOU" not enough but THANK YOU from by bottom of my heart ❤
Oh, thank you so very much for this generous Super Thanks donation to my Channel! I can't tell you how much I appreciate it. I am so very glad that you found my video helpful and that you are now able to save valuable time in your work! Your donation goes towards me being able to create more helpful content, so it is much appreciated. I wish you all the very best. Thank you! ❤️❤️
A year later, these instructions and video editing are still high caliber! You made my month! A big thank you
So glad you found it useful! Thanks for watching my videos!
This saved my sanity. Extremely clear directions. Thanks!
Glad to hear it helped you out! Thanks so much for watching!
I’d spent the past 4 hours trying to figure this out! Thank you thank you thank you!!! No other vids could crack it!!! Elated!!!!
I'm so glad you found my video and that it helped you out! Thanks for watching! Take care!
Wow this just saved me during a data analysis project! OMG. I had watched a couple of other videos but unfortunately couldn't understand them, so yours was perfect. Thank you.
So glad to hear my video helped you out! Good luck with your data analysis project! Thanks for watching my videos!
This was so helpful and saved me 2 hours of manual work. Thank you
I’m so glad to hear you saved valuable time! Thanks for watching!
You are brilliant Sharon! Easy to understand and exactly what i need! Lifesaver!
So glad you found it helpful!! Thanks for the nice feedback. Thanks for watching!
Thank you so very much, Sharon; it's so clear and easy to follow, I Love It!!
You are my hero. THANK YOU for this video.
Aww - thanks! Glad you found it helpful! Thanks for watching!
Your video very useful for me ma'am...
Thank you
Love from India
Thank you for watching! So glad you like my videos!
thanks just followed most of your steps saved hours of time
Awesome! Great to hear. Glad you found it helpful. Thanks for watching!
I love the way you explain and show your screen. Thank you for taking the time to make these videos!!!!
You are very welcome. I’m glad you find my videos helpful! Thanks for watching!
Finally got your video after wasting one full working shift , Thank you
So glad you found my video and that it helped you! Thanks for watching!
Very helpful Sharon. Thank you very much.
So glad you found it helpful! Thanks for watching!
Amazing, thank you. I'll be watching more of your videos in the future.
I'm so glad you found it helpful! Glad you found my channel. Thanks for watching!
Fantastic explainer - i was driving myself mad trying other techniques - thank you for posting this :-)
So glad you found it helpful! Thanks for watching!
Thank you so much for this very helpful video!!!!!!!!!!!!!
Glad you found it helpful! Thanks for watching!
Psych and Chuck?!....love it!
also this was very helpful. Thank you.
Lol! Yes, two of my favorite shows 😉! Glad you found it helpful! Thanks for watching!
This video was exactly what I need I watched multiple others and they got me close but I couldn't highlight them first video to actually fully help me.
Glad to hear this video helped you! Thanks for watching!
wonderful and very clear explanation thank you
Glad you found it helpful! Thanks for watching!
Super helpful, thank you!!
Glad you found it helpful! Thanks for watching!
Great video. I would like it normally, but this like for for the shoutout to Pierre Despereaux.
😂 Thank you for the like!!! He's one of my fav TV characters!
Awesome 👍👍👍❤
Thanks for watching!
well that saved me a load of time. cheers
Glad to help! Thanks for watching!
Thank you, this was really helpful
Glad to help! Thanks for watching!
Great tutorial. I normally use Countif instead of match.
For the conditional formatting instead of entering "....$A2&$B2..." i would enter "....$A2:$G2" so that the whole range is selected.
But great content!
Thanks for sharing these tips! Glad you found my videos helpful. Thanks for watching!
Thanks this is exactly what I needed.
So glad to help! Thanks for watching!
Very informative and easy step by step video.
Thanks
You are verry welcome, Wasim! Thanks so much for watching my videos!
Really nice video
Thank you so much!
I'm so glad you found it helpful! Thanks for watching!
Life Saver. Thank you.🤩
Glad you found it helpful! Thanks for watching!
So helpful thank you😊
Glad to help! Thanks for watching!
This just saved me 4 days of work
That is awesome to hear! Glad it was helpful. Thanks for watching!
Thank you so much!
Glad to help! Thanks for watching!
This was extremely helpful!! Thank you!
Glad you found it helpful! Thanks for watching!
Thank you! Great help
So glad to help! Thanks for watching!
Thank you thank you thank you just wha I need and very clear! cannot thank you enough ;-)
I’m so glad you found it helpful! Thanks for watching!
Thank you so helpful
Glad to help! Thanks for watching!
totally one day wasted, but finally I found your video. Thank you.
So glad you found my videos! Thanks for watching! Glad it helped you out!
THANK YOU FOR THIS!!!
Glad you found it helpful! Thanks for watching!
very helpful,
Thanks!
This is very useful! Thank you very much. Tell me please, is there a way I can export my highlighted (matched rows) to a third spreadsheet?
Many thanks in advance.
Amazing. I need to highlight the cell in left sheet that is found in right sheet but tied to a 3 column index or key.
Thank you!
You are very welcome! Thanks for watching!
The legend, Sharon Smith everyone.
Thank you! Thanks for watching and subscribing to my Channel! 😊
This tutorial I'm sure can assist me in a project I'm looking at. Can I send an Excel workbook to you and describe what I'd like to achieve from the numbers in the workbook. You don't know it but you may well be solving an issue in the Rail and Maritime Industry..
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.
Thank you so much
Glad to help! Thanks for watching!
Hi Sharon! I have a master list of data consisting alpha numeric values in Column A in a specific order, In column B some of the values are the same but in a different order. How do I get the matches to be side by side?
How did you get the split window thing? My Excel doesn't do that when you click the minize button
That is a feature in Windows 11. You should see that option when you hover over the minimize button if you are on Windows 11. Hope this helps! Thanks for watching!
Hi, that's really helpful. what is the screen recording software please? . Watching from Germany
The formula is not working I can't highlight the entire raw just the cell. Someone knows why???😅😅😅
Same here
Edit: I used the VLOOKUP function and worked out
If you kindly make a video on sitting arrangement in excel, it will help me
I use when the data is very huge and if you want to find mathicng values and also identify which cell it is matching use this formula: =IFERROR("B is Present in A" & MATCH(B2, A:A, 0), "B is Absent in A")
Does this work only for unique number values? What if I have a bunch of text in 2 columns? (Verbatims in this case)
Hi.. this is the solution i have been looking for. However, when I am selecting the column it not selecting it. What should i do?
Hi. I a number that I need to find in a column. which is clubbed amount of 2 numbers or more in another table. How I can find that numbers? Like I want to find what numbers are adding up to make $3000. is there any way?
Hi Sharon, have a query could you pl help?
I have a list of employees like first name, middle name and last name in one file and in another file the names are in some different pattern. Can i find the most close match names?
Thanks
Thanks for watching!
Is there any other way to highlith all row, because my sheet goes upto Z column.
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?
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.
It didnt work for me when trying to writte it down but if I used the function button it was all good, thanks!
Glad you got it working! Thanks for watching!
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
How to I lookup value, if my lookup array is scattered all from A1 to Z50 (multiple rows and columns)?
I have unique ID in one row in one sheet, and same or different IDs scattered from A1 to Z50 in sheet 2
i have to search and lookup if data matchs from sheet1 to sheet 2,
how do i lookup in multiple rows and columns??
Mam, how to change multiple different numbers in multiple cells into one unique number
for e.g. change 1,2,3,4,5.......into any unique no. suppose into 99.
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.....?
what if name does not match? example: Miller Andrew G. and Miller Andrew. But I need to select those as match since day have the same birthday
How can I find partial match based on first 7 digits?
This was helpful but now I’m trying to figure out how to match the data from
One column to the next couple of columns over and have it highlight the exact match
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)
Thanks for sharing this helpful tip!
what if we dont have something uniq :( i have emplyee namein different cells :(
smile on champ
Thanks for watching!
How to you get it to return 'Yes' or 'No' rather than True or False?
My formula keeps changing cells down by one for sheet 2 so I'm not getting the correct answers. Nothing of any videos I've watched is helping....frustrating the crap outta me and supposed to be so easy to do
👍
Thanks for watching!
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
It seems like you want to use the VLOOKUP formula in Excel to compare the values in cells C1 and D1, and if they match a pair of values in columns A and B, you want to display the corresponding result in E1. Here's how you can do that:
Assuming your data is in columns A, B, C, and D, and you want to check if the value in C1 matches a value in column A and the value in D1 matches a value in column B, and then display the corresponding result from column E in cell E1, you can use the following formula in cell E1:
=IF(AND(C1"", D1""), IFERROR(VLOOKUP(C1&D1, A:B, 2, FALSE), ""), "")
It seems like you want to use the VLOOKUP formula in Excel to compare the values in cells C1 and D1, and if they match a pair of values in columns A and B, you want to display the corresponding result in E1. Here's how you can do that:
Assuming your data is in columns A, B, C, and D, and you want to check if the value in C1 matches a value in column A and the value in D1 matches a value in column B, and then display the corresponding result from column E in cell E1, you can use the following formula in cell E1:
excel
Copy code
=IF(AND(C1"", D1""), IFERROR(VLOOKUP(C1&D1, A:B, 2, FALSE), ""), "")
Let's break down the formula:
AND(C1"", D1""): This part checks if both cells C1 and D1 are not empty.
IFERROR(VLOOKUP(C1&D1, A:B, 2, FALSE), ""): If both C1 and D1 are not empty, this part combines the values in C1 and D1 using &, creating a lookup value. It then performs a VLOOKUP in columns A and B using the combined value as the lookup value. The 2 specifies that we want to retrieve the value from the second column (B) of the range A:B. The FALSE argument ensures an exact match. If there's an error (meaning no match was found), it returns an empty string ("").
The outermost IF() checks if both C1 and D1 are not empty. If they are empty, it returns an empty string.
So, if the values in C1 and D1 match a pair of values in columns A and B, the corresponding value from column E will be displayed in cell E1. If there's no match or if C1 or D1 is empty, cell E1 will be empty.
You can drag the formula down in column E to apply it to other rows if needed. Just remember that this formula is case-sensitive, so make sure the values in columns A, B, C, and D match exactly.
Hope this helps! Thanks for watching!
Do you know that you are amazing and gorgeous in beauty, I have a question is there a function or code to compare two cells for a percentage, whether it is text or Numbers.
well, I thought this was going to be easier...
Not sure if you monitor this video for comments but I can’t find any instructional videos for comparing two columns to find a matching name IN A TEXT STRING.
Ie one cell may be Mr. John smith in one column and John Smith , Mr. in the second column.
I want to be able to match the name Smith. Thank you. I do find your explanation easy to understand so I’m hoping you have a simple solution
Very nicely done--thank you!
You’re welcome! Glad you found it helpful! Thanks for watching!