I was searching forever to find this solution, thank you so much. I went through so many videos and all were only on outputting matches, not a list of unmatched. Perfection!
My long standing problem is solved with this concise and to the point explanation. Thanks a million. Kindly explain how do we apply this formula when we have more than two columns to compare.
This is the only video that actually enabled me to match names from two lists in a way that is easy to understand-thankyou. Is it true that to do this with v-lookup, if I have a spreadsheet without a common identifier (such as staff number) that I'm unable to do the match? I had two staff lists- one with unique identifiers, and one without.
Great video. Thank you for just getting down to business without glitzy futuristic star wars videos and music. I subscribed and look forward to seeing more.
Thank you for all your videos. You are a great trainer. Please how can I Compare two lists A and B in different workbooks? List A is the standard. If there are differences in List B, we copy the correct value from A to list B.
Bring both of them into a third workbook using query/connection. (This will allow them to update by themselves if the content of either of those 2 workbooks updates). Then compare them using the method shared in the video. That's all. (Tip : Tables with specific names can be accessed anywhere through the workbook, doesn't need to be in the same worksheet.) P.S. : not sure if all this works in older versions of Excel, but sure about 365.
If list two had as an example, Andy (Name). How would I set my formula up so I tell excel to use contains Andy because if I am using 0 to return exact value it shows N/A
Thanks Sir very helpful Sir if I have four to five lists and I want to compare it with main list and the extract names from main list which are not in other five lists
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?
I have multiple emails listed on single cells separated by commas, and I have a master file email list, I am trying to find common emails listed on the look up data that is present on the master file, those that are not listed on master file and those not listed on look up data. I understand the xmatch function however, there are multiple emails in a single cell and in master file just 1 email. Pls assist
exodus as fawn time of distance versus changes of f.e.a.r assymptope, ISO TRADERS beware - causality of featuring, a lead expression of destiny/fate, sudoku error maker, gravijas of demi natured preference, use with care. Haiku#
I was searching forever to find this solution, thank you so much. I went through so many videos and all were only on outputting matches, not a list of unmatched. Perfection!
There’s always an Indian superhero to save the day when it comes to excel… thank you..
You are very welcome!!!
This is the most concise and useful explanation I have managed to find on the subject. Thanks a million!
My long standing problem is solved with this concise and to the point explanation. Thanks a million. Kindly explain how do we apply this formula when we have more than two columns to compare.
Excellent step-by-step detailed explanation. Thank you! First time in your channel and looking forward to your content.
Thank you for such a wonderful, complete, incredibly helpful solution to my problem!
Phenomenally well explained and extremeley useful. Thank you!
Glad it Helped!!
Wonderful job very clear and organized
Thank you 🙏
You’re welcome 😊
You saved my day bro. great explanation
Glad I could help
After searching so many videos, finally arrived at this exact match.thank you
Glad this helped!!
SPECIAL Thanks for your supportive and excellent video tutor
Best video on this subject by far!
Glad it Helped!!
Very helpful ! Thank you so much !
Thank you so much for posting - I'm very grateful.
This is the only video that actually enabled me to match names from two lists in a way that is easy to understand-thankyou. Is it true that to do this with v-lookup, if I have a spreadsheet without a common identifier (such as staff number) that I'm unable to do the match? I had two staff lists- one with unique identifiers, and one without.
Great video. Thank you for just getting down to business without glitzy futuristic star wars videos and music. I subscribed and look forward to seeing more.
This is super.. It works well .. ! Thank you
Glad it helped!!
Thank you. Very helpful
Glad it was helpful!
Thank you for all your videos. You are a great trainer.
Please how can I Compare two lists A and B in different workbooks? List A is the standard. If there are differences in List B, we copy the correct value from A to list B.
Bring both of them into a third workbook using query/connection. (This will allow them to update by themselves if the content of either of those 2 workbooks updates). Then compare them using the method shared in the video. That's all. (Tip : Tables with specific names can be accessed anywhere through the workbook, doesn't need to be in the same worksheet.)
P.S. : not sure if all this works in older versions of Excel, but sure about 365.
Amazing!! Just what I was searching for🤩 Thank you so much!!
Congrats for 9 k subs sir 🥳👍🏻🥳🤟🏻
Thank you Ansh….
@@TEKNISHA Anytime!!!
what if the user does not have 365, is there another formula to get the same result? Thanks
this is incredible and really useful - thankyou for your time!
What happens when the list has duplicate names? Will the result be messed up.
Thanks so much!!!
Brother thanks a lot. Is this formula works on numbers
Great video!
This is so helpful, thanks!
If list two had as an example, Andy (Name). How would I set my formula up so I tell excel to use contains Andy because if I am using 0 to return exact value it shows N/A
Bro I think I need this video. Thnq u bhai
wonderful thank you boss
Most welcome
Love it, LOVE IT!! 😁
Good video, clear explanation.
great help !
Glad it Helped!!
Thanku so much sir...
Saral bhasa me hota or v behtr lgta❤❤❤
Thanks for this👌👌👌
Most welcome 😊
excellent
Helped a lot
This is brilliant!
thanks a lot
XMATCH automatically defaults to 0-Exact Match. So there is no need to type the ,0 in the formula when looking for an exact match.
Excellent 👍😊
How to use the same formula or list down common items, missing items etc for 3 or multiple columns instead only 2 column
Thank you so much ... I could do my comparison ... 🤣
Thanks Sir very helpful
Sir if I have four to five lists and I want to compare it with main list and the extract names from main list which are not in other five lists
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?
What if I need to find out multiple information?
I have multiple emails listed on single cells separated by commas, and I have a master file email list, I am trying to find common emails listed on the look up data that is present on the master file, those that are not listed on master file and those not listed on look up data. I understand the xmatch function however, there are multiple emails in a single cell and in master file just 1 email. Pls assist
i need 4th criteria where I should get unique from both tables and also the not unique values below them. in a new table.
I am having trouble saving the document when finished.
How does is work on google sheets?
What is the alternative to filter function
Why didn't u use only v look up?
If list 1 double item ,so how we doing
Filter function is not in my excel
please share the excel sheet
exodus as fawn time of distance versus changes of f.e.a.r assymptope, ISO TRADERS beware - causality of featuring, a lead expression of destiny/fate, sudoku error maker, gravijas of demi natured preference, use with care. Haiku#
I am too stupid to do this.
Lol
Thanks a lot!