**GET FOUR FREE COURSES!** ► www.simonsezit.com/four-free-courses We have additional free Excel training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html Check out our FREE 300+ hour training course playlist here ➡ 🔥ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Happy to have opened this post as this helps a lot as i 'm just new in my new role at the office and i need a lot of reporting/comparing cases to do! This is much appreciated!❤
Thank you for your kind words! I'm so happy that the video was able to provide you with the information you needed. 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support!
I usually use "IFERROR" function for that, but "ISNA" looks helpful too, and it's another tool to use... always good to know more than one way to handle things. Thank you for this informative tutorial!
in addition you can use the function 'ifna(function, return value when na)' - or 'iferror(function, return value when error)' which will also cover div/0 etc. also useful if you rather want to leave the cell empty
Wow, thanks! Glad it was helpful. 🤩 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support!
What do you see as the benefits of using Lookup vs Conditional formatting the cell ranges based on based on ? For example, using something like "=A1Sheet2!A1" as the conditional formatting formula.
Also, very nice is the fact you can move the columns around from the 1st or 2nd dataset in either left or right direction without breaking the formula!
Fantastic video. Only gripe I have, is that sheet number two (Employees 2) is called almost exactly the same as the named datarange (Employees2). Can be a bit confusing.
Glad you it was helpful. Thanks for watching! 🙂 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
Pro tip! When you have a spreadsheet with a lot of columns: just make sure that the column with the lookup value is simply left of the column you want to search in. The Vlookup function can only search to the right!
I had similar experience last year wherein I needed to compare a list of 400+ tickets our team has against a list from our Finance team. I did the same process (VLOOKUP, IFERROR, and Conditional Formatting) which was great but I noticed that some items can be in file A but not in file B, or vice versa. That vice versa thing was a headache for me. Looking back at the situation, I think I may just did an overthinking and that I could have just done the same process in both directions.
I have watched, let's just say, "my fair share" Excel VLOOKUP videos, but they did not click click with me. This video clicked. It all made so much more sense than the other "experts" out there. The first time through I was like Ohhhh that's how I need to view the Lookup Value. You gave criteria for it and you made it MAKE SENSE. So I was pretty stoked when my VLOOKUP actually did what I wanted it to do. Then I got my data cleaned up with your other tips and tricks. Lastly, I do appreciate the context you provided for your examples. If there was an award for "Best VLOOKUP Video on the Interweb" You should certainly win that award, and I feel so strongly about that, I would likely throat-punch anyone who disagreed with that sentiment. :-) JK. Probably. Also a very pleasant voice. Not an "I'm a super brain and you're a moron voice, just a pleasant, confident, knowledgeable voice. Thank you for saving me from VLOOKUP hell. You are Awesome Sauce, no doubt about it.
Sorry. It works perfect on worksheet but "wrong formula" in conditional formatting. I tested separately in two separate columns but got the same result. I am using Excel 365. May I know why? Many Thanks.
I tried this on two datasets I am trying to compare and every result is #N/A. I know there are values that match between both. I verified all cells are formatted as text. Not sure what else I can do to resolve the error. Stumped.
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?
Good day, what if the details are not exactly the same like the names have the titles i.e “dr” or it’s the first name that comes first instead for the last name
You're welcome! We're so glad you're enjoying our videos. 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support!
Can someone share me a link through which I can learn stock count or like I have a huge sayad which is present stock available and physically count stock with quantity and how to workout to find the variance. Thank you in advance for your help
i have a problem.. all is good when i did the formula on first cell. but when i drag to have the formula in subsequent rows.... it just copies my answer on first row.. to all subsequent rows..
This helped me a lot in my accounting job. Issues with operations team backdating job numbers without letting accounting know. Therfore running this report using v look up helped call them out
QUESTION: I have 2 lists that were generated by 2 different databases. one formulates names DOE, JANE SARAH...the other formulates each name in a different column and every name written as Doe Jane Sarah instead of upper case. So I CONCAteNTATED the names from the list that had the name separated in columns, then I did =UPPER() to make the names all upper case. I then copied and pasted as a "paste special" so that it copies as the final value instead of the formula. so the names look exactly the same. Then i tried conditional formatting and couldn't find any matches, even though I know there were at least 10 just visually. then, to add to the mystery, I hand typed one name in the same format as the DOE, JANE SARAH... and this is the only name that matches with conditional formatting or VLOOKUP. I've diddled around in a few cells just to see if there are extra spaces or something and it doesn't seem like it. I copied it into googlesheets and tried conditional formatting and got the same weirdness. What am I doing wrong? why are these names that visually look 100% identical not finding their matches? help!
Hello, thank you for useful video, maybe you can add how I can compare 2 lists and add missing data? For example, if I have "Taylor Gross+ in the Column 1 but don't have it in column 2, I want to add "Taylor Gross" to column 2.
You are very welcome! Glad it was helpful. 🙂 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
Hello I want the two tables side by side on one sheet, sort both table for the employee id to be smaller to largest and use vlookup function to find the employee id that exists in one table but does not in the other table and vice Versa. What I am struggling with is this: Let’s say there are 10 employee ids in table1 and 9 in table2. And employee id no. 4 is missing in table2 I want to add a row in table 2 to indicate that the entry is missing and move employee ids from 5-10 a row below to match with the entries in table1 How do I do this?
Glad you enjoyed it. Thanks for watching! 🙂 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Thank you so much for your kind words! 😊 We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support!
You are very welcome and thank you so much for your support! We really appreciate it🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support! #SimonSezIT #Excel
**GET FOUR FREE COURSES!** ►
www.simonsezit.com/four-free-courses
We have additional free Excel training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Check out our FREE 300+ hour training course playlist here ➡
🔥ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Happy to have opened this post as this helps a lot as i 'm just new in my new role at the office and i need a lot of reporting/comparing cases to do! This is much appreciated!❤
Glad you think so! Thanks for leaving as comment ;-)
This is the most comprehensive video explaining what to do. Thank you so much.
Thank you for your kind words! I'm so happy that the video was able to provide you with the information you needed. 😊
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
I usually use "IFERROR" function for that, but "ISNA" looks helpful too, and it's another tool to use... always good to know more than one way to handle things. Thank you for this informative tutorial!
Happy to help!
This is really helpful. Now I’m able to compare my reports more effectively.
Thank you so much 😀
nicely explained and I could able to implement easily. Thank you.
Wow, thanks! Glad it was helpful. 🤩
in addition you can use the function 'ifna(function, return value when na)' - or 'iferror(function, return value when error)' which will also cover div/0 etc. also useful if you rather want to leave the cell empty
Thank you for explaining this, everyone else always uses technical terms and it doesn’t connect in my head.
Glad you like them! Thanks for watching 😊
Thanks for the help
You are very welcome! Thanks for watching 😃 Learn more Microsoft Excel Tips and Tricks here ➡️
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
Exactly what I needed!!! Thank you so much
Wow, thanks! Glad it was helpful. 🤩
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Thank you !!
Thank you
Thanks
You are very welcome 🙂
What do you see as the benefits of using Lookup vs Conditional formatting the cell ranges based on based on ? For example, using something like "=A1Sheet2!A1" as the conditional formatting formula.
Very nice !!
Also, very nice is the fact you can move the columns around from the 1st or 2nd dataset in either left or right direction without breaking the formula!
Fantastic video. Only gripe I have, is that sheet number two (Employees 2) is called almost exactly the same as the named datarange (Employees2). Can be a bit confusing.
good explanation, but image is very blurry.
very useful
Glad you it was helpful. Thanks for watching! 🙂
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
if function is much easier than vlookup comparison. if(Table1[column1]=Table2[Column1],,"Missed") ❤
Thanks for sharing!
Not really, in case there are different ID on the same row.
This was stellar! Clear. Detailed. To the point. Thank you very much for making and sharing this video.
great
What if you want to compare more than 1 Collum
superb. thank you
You are most welcome 😊
Brilliant!! I'm an Accountant, tracing missing invoices from Revenue Authority was my biggest problem.
Is it the right function to use with bank reconciliation in excel please ?
Exactly what I was looking for. Thank you for making a potentially complicated process clear and easy to follow. I’ll be watching again.
Pro tip! When you have a spreadsheet with a lot of columns: just make sure that the column with the lookup value is simply left of the column you want to search in. The Vlookup function can only search to the right!
I had similar experience last year wherein I needed to compare a list of 400+ tickets our team has against a list from our Finance team. I did the same process (VLOOKUP, IFERROR, and Conditional Formatting) which was great but I noticed that some items can be in file A but not in file B, or vice versa. That vice versa thing was a headache for me. Looking back at the situation, I think I may just did an overthinking and that I could have just done the same process in both directions.
I have watched, let's just say, "my fair share" Excel VLOOKUP videos, but they did not click click with me. This video clicked. It all made so much more sense than the other "experts" out there. The first time through I was like Ohhhh that's how I need to view the Lookup Value. You gave criteria for it and you made it MAKE SENSE. So I was pretty stoked when my VLOOKUP actually did what I wanted it to do. Then I got my data cleaned up with your other tips and tricks. Lastly, I do appreciate the context you provided for your examples. If there was an award for "Best VLOOKUP Video on the Interweb" You should certainly win that award, and I feel so strongly about that, I would likely throat-punch anyone who disagreed with that sentiment. :-) JK. Probably. Also a very pleasant voice. Not an "I'm a super brain and you're a moron voice, just a pleasant, confident, knowledgeable voice. Thank you for saving me from VLOOKUP hell. You are Awesome Sauce, no doubt about it.
Oh wow, we are so stoked by what you just said. Thank you so much, as much as we are glad that you found our tutorial/s helpful. 😊
Sorry. It works perfect on worksheet but "wrong formula" in conditional formatting. I tested separately in two separate columns but got the same result. I am using Excel 365. May I know why? Many Thanks.
I tried this on two datasets I am trying to compare and every result is #N/A. I know there are values that match between both. I verified all cells are formatted as text. Not sure what else I can do to resolve the error. Stumped.
Try, =IF(A1Sheet2!A1,"Missing Record",""). Thanks to Seiha Sky for suggesting.
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?
Love the explanation but do you have a spread sheet so I can try the formula as you explain?
Have you heard about IFNA function?😂.This can do this thing more easily😅
I followed the steps, and my results were 0. Is there a reason it keeps coming up as 0?
Good day, what if the details are not exactly the same like the names have the titles i.e “dr” or it’s the first name that comes first instead for the last name
Oh my goodness! You are lifesavers! Wonderful narrator and brilliant process. Thank you so much.
Been trying to figure this out for YEARS. It just clicked! Thank you for making this very clear.
That is great, thanks for sharing 😊
I have been watching your videos, for 3 days
And there's no words to be described,
You're just amazing, Thank you!
You're welcome! We're so glad you're enjoying our videos. 😊
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
My Motion looks nothing like that....How do I color code?
Can someone share me a link through which I can learn stock count or like I have a huge sayad which is present stock available and physically count stock with quantity and how to workout to find the variance.
Thank you in advance for your help
My version wont let me name the table.... :(((
i have a problem.. all is good when i did the formula on first cell.
but when i drag to have the formula in subsequent rows.... it just copies my answer on first row.. to all subsequent rows..
I would say this task is not complete. What about the data on Employee list 2 that is not on Employee List 1?
This helped me a lot in my accounting job. Issues with operations team backdating job numbers without letting accounting know. Therfore running this report using v look up helped call them out
QUESTION: I have 2 lists that were generated by 2 different databases. one formulates names DOE, JANE SARAH...the other formulates each name in a different column and every name written as Doe Jane Sarah instead of upper case. So I CONCAteNTATED the names from the list that had the name separated in columns, then I did =UPPER() to make the names all upper case. I then copied and pasted as a "paste special" so that it copies as the final value instead of the formula. so the names look exactly the same. Then i tried conditional formatting and couldn't find any matches, even though I know there were at least 10 just visually. then, to add to the mystery, I hand typed one name in the same format as the DOE, JANE SARAH... and this is the only name that matches with conditional formatting or VLOOKUP. I've diddled around in a few cells just to see if there are extra spaces or something and it doesn't seem like it. I copied it into googlesheets and tried conditional formatting and got the same weirdness. What am I doing wrong? why are these names that visually look 100% identical not finding their matches? help!
Hello, thank you for useful video, maybe you can add how I can compare 2 lists and add missing data? For example, if I have "Taylor Gross+ in the Column 1 but don't have it in column 2, I want to add "Taylor Gross" to column 2.
This Really helped me a lot, great video, Thank you.
You are very welcome! Glad it was helpful. 🙂
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
the best explanation about vlookups,
Glad it was helpful!
Hello
I want the two tables side by side on one sheet, sort both table for the employee id to be smaller to largest and use vlookup function to find the employee id that exists in one table but does not in the other table and vice Versa.
What I am struggling with is this:
Let’s say there are 10 employee ids in table1 and 9 in table2. And employee id no. 4 is missing in table2 I want to add a row in table 2 to indicate that the entry is missing and move employee ids from 5-10 a row below to match with the entries in table1
How do I do this?
Thank you for this can I request for sample excel template touse for practice thanks
Very clearly explained. the video covered all that was required. Thank you so much!!
Thank you and you're very welcome!
What if we are searching for approximate values instead of exact?
1:03 for non-Anglos who don't do long-winded presentation intros
Excellent one this one is what i really wanted...Thank u
Happy to learn it was helpful, Vignesh :-)
love this function, thanks
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
Thank you baby jesus for this help
Thank you for clearly explaining how to do a VLOOKUP :)
Thank you so much for the very easy guide. The explanation was clear, precise and step by step. Looking forward for more videos.
Glad you think so, Adina. Thanks for watching!
Five star explanation of vlookup functions and conditional formatting. Great.
Wow, thanks! Glad it was helpful. 🤩
How do we get the data to practice with it.
The easiest is to filter the NA
This was extremely useful. Thanks a lot!!
great work! well done! now I see it clear ... ;-)💯
Glad you enjoyed it. Thanks for watching! 🙂
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Thanks for the VLOOKUP life preserver. You are so appreciated!
Thank you so much 😀
This is so helpful. Thank you for being so clear and precise.
Easy to understand the steps
Great tutorial!! THANK YOU!!!
You are very welcome! Thanks for watching :-)
MEGA!! Excellent explanation and flow.
Thank you for the kind words! Glad it was helpful. 🤩
Thank you very much for this. This is indeed useful.
Glad you enjoyed it. Thanks for watching! 🙂
What a voice
Thank you so much for the kind words!
nice. put practiced file in the description video ...
Amazing video, thanks! I have recently used extraktAI for Vlookup, but it was for customer and product ID, it also worked really well!
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
Please share excel practice file
Best Tutorial ever O.O!!!!!!!!!!!!!!
Excellent tutorial. Very clear and concise. Thank you.
Thank you so much for your kind words! 😊
We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Fantastic
Glad you enjoyed it. Thanks for watching! 😃
Thanks for this. Really helped.
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
Clear ❤
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
awesome!
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
Thank You!!
🥰Thanks!
You are very welcome and thank you so much for your support! We really appreciate it🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
#SimonSezIT #Excel
Thank you!
Really helpful
Thank you
great thank you
Excellent tutorial
Thanks Alex!🙂
Thank you
Wow! This will be very helpful. Thanks for sharing.
You’re welcome 😊 Thanks for you watching!
Thank you for the help
Great
This will be very helpful, thanks for sharing.
Happy to help!
Great lesson and video, thank you!
You're welcome!
brilliant
Thanks! Delighted you think so!
Thank you for sharing the video
Thanks for watching, Divya!
thank you
GOD Bless you
Glad we could help!
Thanks
Great!
Really appreciate the way you teach!
Glad to hear that!
You’re a life saver. Very clear and precise.
Glad it helped Lala 😊
You've explained this so clearly! Thank you!!
Glad you liked it! 😊
Great tutorial thanks for sharing.
Glad it was helpful! Thanks for watching 😃