VLookup on Multiple Sheets in Excel

[@ethanpavel1486]

Thank a lot sir, been searching for this treasure😂😂😂😂😂😂 for 4 years and finally found........ Simply like and subscribe.

[@Syedhussainipage]

Thank you for the feedback Ethan, it helps in keeping me motivated. I am so happy it worked for you. Best Regards, Syed H

[@ramesh-vm5gq]

Before I have watched more than 10 youtube channels but I didn't understand now I understood one single video thank you so much sir.......

[@jollywolly2571]

I rarely comment. This is worthy! Very good explanation and exactly what I have been searching for for months!

[@Syedhussainipage]

@@jollywolly2571 I am so happy it worked for you. Thank you for taking time to add your helpful feedback.

[@bradygrabowski5520]

Thank you for this incredibly succinct and helpful tutorial! You just saved me countless hours of inherited data management.

[@Syedhussainipage]

Thank you for the feedback, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@suboomdeb3572]

Saved my time, made it easy. Thanks for teaching us.

[@Syedhussainipage]

@@suboomdeb3572 Thank you for the feedback. I'm happy I was able to help. If there is anything else I can help you with, just let me know!

[@itsallenwow]

I was having so much trouble with this, your video was brief but made searching across the multiple sheets I needed super easy. Well maybe not easy, but understandable lol. Great tutorial!

[@davidmeans626]

1:48 into the video and this solved my hair-pulling for the past few weeks, haha. THANK YOU for showing us how to determine the arguments. :D

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@ndutawaweru]

thank you so so much for this video. You have no idea what you have done for my reporting life. I am so grateful.

[@Syedhussainipage]

Thank you for the feedback, it helps in keeping me motivated. I am so glad to hear that it helped you. Please subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@Goonotora]

Thanks Syed, I wasted time on several other videos and it worked with your video! Regards from Germany!

[@Syedhussainipage]

Thank you for the feedback Nadja, it helps in keeping me motivated. I am so happy to hear that it worked well for you. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@richardcranium8776]

Thank you for the tutorial. I viewed a number of other videos before yours and still couldn't figure it out, but your video helped me get the job done within minutes.

[@Syedhussainipage]

Thank you for the feedback Richard. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@bokooo3129]

even though i knew the iferror function i didn't immerse myself enough to get to this knowledge so thank you for the short cut it really saves time, Thank you again

[@Syedhussainipage]

Thank you for the feedback Bokoo, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@josephmathias7021]

The way you explain, soooo nice!!! i know the formula, but i had to start following as a new learner and ofcourse, i enjoyed doing it again👏👏👏

[@Gopinathjayaraman83]

Wow wow …. I was searching for this function for 2 days & this was useful

[@Syedhussainipage]

Thank you for the feedback, it helps in keeping me motivated. I am so glad to hear that. Please subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@rajkumarraj7139]

It's very easy to understand. Tq so much and do more videos like this.🙌🙌

[@janetramirez5860]

THANK YOU! Struggling with a project and this helped so much.

[@Syedhussainipage]

Thank you for the feedback Janet, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@mattmeade983]

easily the best explanation of this idea . Thank you so much!!

[@sidhunani6600]

Thank you so much after seeing so many videos I was so confused to perform on a task, but thisss video made my mind so clear thanks a lot

[@sarikahoshing4662]

Explained so well. was very easy to execute + the practice worksheets are an added bonus.

[@Syedhussainipage]

Thank you for the feedback Sarika, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@daudacademy24]

Awesome, thank you for explained in very easy way. This technic I have never seen before. And hope it will helpfull to me & also to others.

[@ymon1119]

Thank you, you are helping us all, please continue to educate us

[@Syedhussainipage]

Thank you for the valuable feedback Ymon, it helps in keeping me motivated. I am so happy to hear that my videos are helpful. 🙂 Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@manojpawar9618]

Thank so much sir, you saved my extra efforts and time

[@SapnaDevi-g9v]

Finally i understand Vlookup and the practice sheet is the good one

[@mohammedshafeeqpk7600]

I trying to find out vlookup and totally lost and confused by some other vedios, but you make it as a piece of cake. Truly accurate, simple, detailed way of presentation. Looking for more vedios from you.

[@Syedhussainipage]

Thank you for the feedback, it helps in keeping me motivated. Please subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@nomatusi7514]

Me too. This was my 3rd one but I took less than a minute to learn it.

[@DT-mb3bo]

Thanks 😊. This helped a lot. Turned a manual 20 minute job into 5 mins with me figuring out what I did wrong

[@Syedhussainipage]

Thank you for the feedback D, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@lamacumeca]

Exactly what I was looking for ... clear and concise. Thank you.

[@3ASLog]

Very well professionally explained, hats-Off to you Janab, ALLAH bless you, I solved my issue :)

[@Syedhussainipage]

@@3ASLog Thank you for this lovely feedback and thank you for the blessings.

[@vlogsnoor]

Wow, very easy way to guide, thanks for helping

[@Syedhussainipage]

Thank you for the feedback Noor, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@segundaeucontinuo1043]

thank you!!!!!!!!!! So much easier than the other options!

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@nomatusi7514]

Well explained. I tried learning from other youtube but I could not get it. When I watched this one it took me less than a minute.

[@sumanmukherjee4710]

Ur videos r excellent and ur example files are very helpful. Thank you so much....

[@Syedhussainipage]

I am so happy to hear that. Thank you for the feedback, Suman. It helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@AMOOBABATUNDEYAKUB]

This is my first time coming across your video on YT and your pragmatic methodology is the best for excel learning so far. Kudos.

[@Syedhussainipage]

Thank you for the feedback Amoo, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@AMOOBABATUNDEYAKUB]

@@Syedhussainipage Done. I will also like to see a video of you for Vlookup of multiple sheets (Jan: Dec) for sales and Annual leave plan Your presentation should be better than that of others.

[@nomatusi7514]

I would get lost when watching other videos online. This one is well explained.

[@Syedhussainipage]

Hey sorry for delaying my response. Here is a video to lookup in multiple sheets/tables: kzbin.info/www/bejne/lZayopyvrKxosNU

[@indupuri613]

O my good i also suffered from this desease... But you gave me. A solution....👍👍👍

[@karengarcia7528]

Thank you for explaining it so well. I definitely agree the more you practice the better you retain the information. Thank you Syed.

[@Syedhussainipage]

Thank you for the feedback Karen, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@chandrasekar6747]

thank you very much sir, I under stand there are good people around us. Thank for your tutoriol.

[@seragbugaighis8777]

a great tutorial in all aspects simple clear concise...thank you

[@Syedhussainipage]

Thank you for the feedback, it helps in keeping me motivated. I am so glad to hear that. Please subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@avivaconstantine2472]

Thank you so much for sharing this process!

[@Syedhussainipage]

Thank you for the feedback Aviva, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@pavanpabolu]

Superb. Helped me a lot. Thank you sir.

[@Syedhussainipage]

Thank you for the feedback Pavan, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@natalyakhimka4988]

Great! Thank you a lot for this video! that is exactly what I was looking for

[@Syedhussainipage]

Glad it was helpful!

[@Yapile]

Great explanation. How do I use it if I have many tabs? Is there a shorter way to "tell" it look at all tabs at once?

[@Syedhussainipage]

Hello there, Thank you for your message. You can combine the data into one master sheet that you can use for your lookups. Check out this video to see how to combine data from multiple sheets for vlookup: kzbin.info/www/bejne/gIq9ZoCIa8pph9U Let me know if you have any questions.

[@JTJRColonial]

Syed this was super helpful for me. Thank you!

[@samgergianaanjao8473]

You are a great teacher Syed! Very clear explanations. I am enjoying and learning a lot! THANK YOU THANK YOU!

[@Syedhussainipage]

Thank you for the feedback Sam, it helps in keeping me motivated. I am so glad to hear that. Please subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@MeeRavi17]

Thank You so much for this great video

[@sakshipardeshi679]

Thank you so much for this video ❤❤

[@pradeepg4498]

Excellent,super and master of all ♥️

[@Syedhussainipage]

Thank you for the feedback Pradeep, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@carolinlouis3758]

Thanks a lottt! Was trying to find a relevant one from weeks, all the others are so complicated. Thank You!

[@Syedhussainipage]

Thank you for the feedback Carolin, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@diktisukorejo4028]

very helpful, thank you very much 🙏

[@Syedhussainipage]

Thank you for the feedback Dikti, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@realTVN]

Hi quick question is there a way to look up any sheets? not just 3 sheets but every tabs? Thank you

[@jonluciano1690]

Thank you sir for your tutorial, it really help me a lot, but I run into a problem. Some data are available both in 2 worksheet and it gave out error since it is duplicate. Any suggestion to elimanate the error?

[@artie_craftie]

Clear explanation sir...thank u for this video😊😊

[@Syedhussainipage]

Thank you for the feedback, Sahaana. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@JIGSonYT]

So very helpful in my work i can now reduce time on doing my reportings. Thankyou

[@Syedhussainipage]

Thank you for the feedback Ling, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@faizanasghar6950]

very nice explanation Sir Thanks a lot.

[@Syedhussainipage]

Most welcome

[@bhaskarchakrala1312]

Thank Syed. Simply and required information covered. Thank you

[@Syedhussainipage]

Thank you for the feedback Bhaskar, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@surajdasanayake352]

Thanks, Syed,...it helps me a lot!!

[@Syedhussainipage]

Thank you for the feedback Suraj, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@KeithPitman-q5o]

Thank you very much... helped me to figure out how to check a third tab. One question though - i would like still to utilize the "not found" message returned if the exact match is not found. In theory, I am thinking I need to add another "IFERROR" statement that encompasses all three tables then add a comma and "not found"... but its not working for me. Am I missing something?

[@Syedhussainipage]

@@KeithPitman-q5o Thank you for the helpful feedback. Could share a sample data and the formula you're using, I can inspect it closely and spin up something for you.

[@KeithPitman-q5o]

@@Syedhussainipage i used to start a new spreadsheet each year at work but last year i got smart and decided to just add tabs for each year... starting this year I was challenged in searching 2 different "year" tabs but figured it out using: =IFERROR(VLOOKUP(B2,'2023'!D:F,3,FALSE),IFERROR(VLOOKUP(B2,'2024'!D:F,3,FALSE),"Check your number, Dummy")) [The "dummy" part is for me since I'm the one using it... figured why not have fun with myself... i just sometimes like to change it up]. But now with a new year coming up, i needed to figure out how to search over 3 years (and ultimately additional years) and failed miserably at all my attempts on my own... your video helped me out (thank you again) in searching over 3 years when I tested my 2025 tab by using: =IFERROR(IFERROR(VLOOKUP(B2,'2023'!D:F,3,FALSE),VLOOKUP(B2,'2024'!D:F,3,FALSE)),VLOOKUP(B2,'2025'!D:F,3,FALSE)) Is there a way to keep the personal note ("check your number, dummy") to myself? And I guess if you could help on this, what happens a year from now if I have to search over 4 years... or 5 years... or 6? Is this going to be possible?

[@manojjayasuriya8459]

Superb Explanation. Great to learn from you

[@abdurahmanfaisal6835]

I have the same scenario and there are 15 sheets. The data is in column 10 of each sheet. I can use one "IF ERROR" right ? Should I use nested "IF ERROR" ?

[@Syedhussainipage]

Hey, I am so sorry for delaying this message. You can use either one, just the approach will be different depending on the data.

[@harikrishna2195]

Very nice explanation I got solution for my problem

[@PMK2111]

Very crisp and precise....thnk you

[@Syedhussainipage]

Thank you for the feedback Priya, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@merryfefrondozo1177]

Clear and precised. Thank you sir!

[@Syedhussainipage]

Thank you for the feedback Merry, it helps in keeping me motivated. I am so glad to hear that. If you haven't already, please subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@1Teebrii]

Clear, concise, and perfect!

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@thenseerm371]

Really helpful, Thank you !!!

[@Syedhussainipage]

Thank you for the feedback Thenseer, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@sugulin9958]

Thank you so much! You made it so easy 😊

[@Syedhussainipage]

Thank you for the feedback Su, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@Lufc-Chaddy]

thank you very much this will come in very handy

[@Syedhussainipage]

Thank you for the feedback Ian, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@Lufc-Chaddy]

Have done my friend

[@Syedhussainipage]

@@Lufc-Chaddy Thank you Ian 🤠👍

[@Lufc-Chaddy]

@@Syedhussainipage I actually turned my data range into tables, works perfectly as below. Thanks again for the great video =IFERROR(IFERROR(VLOOKUP(A2,Table1,5,0),VLOOKUP(A2,Table2,5,0)),VLOOKUP(A2,Table3,5,0))

[@basilmathew5728]

Really helpful, much appreciated to your language.

[@Syedhussainipage]

Thank you for the feedback Basil, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@BigBang4821]

is there a faster way than nesting IFERROR 100 times if there are 100 tables to look for the data in different sheets?

[@nheynazvic6563]

Thank you very much for this sir...

[@Syedhussainipage]

@@nheynazvic6563 Your welcome! I'm happy I was able to help! ☺️

[@indersingh469]

Really nice.. Vlookup+Indirect also can solve this with one vlookup.

[@dabestgurlukno]

Great video! Very helpful!

[@Syedhussainipage]

Thank you for the feedback dear, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@reniroselachica9222]

tutorial was great thank you!

[@Syedhussainipage]

Glad it was helpful! Thank you for the helpful feedback!

[@jaymehamilton7634]

You are such a great teacher! My project has become the gray in my hair! I have a worksheet with two columns, trying to figure out which are not duplicate, column 1 is a number (classification) and column 2 is job. I have one worksheet for 2022 and one for 2023. I'm at a total loss here. Any help from the genius that is you, would be appreciated. Spent about a week and I'm at a loss.

[@Syedhussainipage]

Thank you for a constructive feedback. You can book 15 to 30 minutes of time with me on a Zoom call so we can quickly go through it and fix any issues you are experiencing. Here is a link to Booking form: meetings.hubspot.com/syed57

[@trixieshaw1632]

Hello, I love your training videos though I will need some assistance as my data has been wiped out. I have a very large database between sheets/ workbook.

[@Tina-fu6rq]

This is helpful! Subscribed

[@paulaguerreiro2023]

Excellent detailed explanation. Just the help I needed. Thank you so much.

[@Syedhussainipage]

Thank you for the feedback Paula, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@kassimmaulid3866]

so great bro

[@Syedhussainipage]

Thank you for the feedback Kassim, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@sharingbysks]

Awesome presentation in video. Can you please share which software you are using for underlining the text and other editing in the video?

[@Syedhussainipage]

Thank you for the feedback, it helps in keeping me motivated. I am so glad to hear that. I am using Techsmith Camtasia, you may find it here: techsmith.z6rjha.net/c/164596/476805/5161 Please subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@HM-uj2mw]

Thank you, brother. I have a question, though. If I use the formula for only 2 tables, I get an error saying, I am missing a parenthesis. Once I add a closing one, I still get an error. For some reason, I am not able to make this work for just 2 tables. Not sure what I am doing wrong.

[@shaunjacobs5259]

What if I have more than 3 tables?

[@ashrafeditor9213]

you are genius excellent work

[@Syedhussainipage]

Thank you so much 😀

[@mehdik525]

Great video ❤

[@delefunmilayo5818]

How do I download the data u uploaded on ur screen from my phone to laptop?

[@FirmanDisini21]

Thank you

[@vashisth.ashpreet]

Ultimate !!! 💐

[@Syedhussainipage]

Thank you for the feedback Ashpreet, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@SudamaKumar-om1uy]

i'm really happy this video

[@Syedhussainipage]

Thank you for the feedback Sudama, it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@abdelrahmanahmed4868]

thanks to much man you just my savior

[@azhar9757]

thanks sir i was looking for this

[@rajanphadke]

Nicely Explained -Clear concept Thanks a lot

[@Syedhussainipage]

I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@letschill4778]

Nice walkthrough! I have the following formula: =IF(IFERROR(VLOOKUP([@Name],sheet1!A:A,1,FALSE),"No")="No","No","Yes") I need the formula modified to execute the same for 3 sheets within my excel file (sheet1, sheet2, sheet3) - Any suggestions?

[@Mathew-q5d]

Jazakallah its helped me allot, just wated to know if there is any alternative coz i have to deal with more than 15,20 sheets

[@nikfarina]

helloo, i tried to use this formula but i received error too many arguments. Can you please help. thank you

[@shibujoseph8498]

thank you soo much sir

[@ericknkonya5682]

I have a quick question what if you have 200 multiple sheets, I think its a lot of work doing the formula for each tab

[@Syedhussainipage]

You are right about that, however, let me see if i could find some other way.

[@ericknkonya5682]

@@Syedhussainipage Thanks would appreciate if you happen to find a way around that.

[@muhammadtouseef5166]

@erick I also have same issue... If you have find any solution plz let me know...

[@Syedhussainipage]

Hello there, You can consolidate data into one master sheet and use it for lookups. Here is a tutorial on how to combine data: kzbin.info/www/bejne/gIq9ZoCIa8pph9U I will soon post a video with a proper explanation on this one. I hope you find this helpful.

[@TheNajibdre]

actually i need to do this for 467 page that i have, is there any option to select them all

[@Syedhussainipage]

Yes, you can do it by combining the data into one big master sheet. Here is a video walkthrough to help you with that. kzbin.info/www/bejne/gIq9ZoCIa8pph9U You can book 15 or 30 minutes of my time for free in case you need a walkthrough using this link: meetings.hubspot.com/syed57

[@Shahzilrind]

Aslamelekum amazing lecture. May Allah swt give you more success ameen

[@Syedhussainipage]

وعليكم السّلام ورحمةاللّٰه وبركاته Thank you for the feedback and blessings Shahzil , it helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@maan5315]

May we use for more than 5 table then how

[@mehdik525]

Nicely explained ❤

[@jeffreyyip5337]

Hi, I tried many time using your method but I still cannot solve it , only can find/match the 3 values wanted out of 10. Do you have any solution?

[@Syedhussainipage]

Can you please share a sample data and add more clarity about what you want so I can help you properly. Submit your sample data here: forms.gle/AVaJ8Q2oYj1QeE236

[@bushra6642]

You saved me, thank you

[@Syedhussainipage]

Thank you for the feedback Bushra. It helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@sonic592]

What if the function finds the same value on both or in all 3 tables? I’m getting #SPILL results because of this

[@affliction504]

same

[@engineerimran2321]

That was a awesome work u did. I appreciate it . Love u from Imran.

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@annietrinh1452]

Very easy to understand but I had a workbook with 210 sheets products... There is anyway to lookup value with shorter code?🥶

[@Syedhussainipage]

Hello Annie, Thank you for the valuable feedback. I am working on a new video that will help you with what you are trying to do. I will post the link here for your quick reference. You may consider subscribing to my KZbin channel kzbin.info and click the little bell icon for notifications of new videos from me.

[@Syedhussainipage]

Hello Annie, Here is the video I promised. kzbin.info/www/bejne/gIq9ZoCIa8pph9U Hope you find this helpful. Let me know if you need any help. Best Regards, Syed H