How to VLookup in Differrent Workbook

Thank you very much. easy, fast, to the point without all the other talks.

What if you have last names and and you need to find full name and employee id?

Great easy to follow video. Does the data remain in Book 1 if you close Book 2?

And how when closed other workbook then data link disappear?

Thank You so much God bless you !

THANKS! The first one that made sense to me!

Awesome, thanks

Important 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! Good luck 😊

How to fetch fullname and email using one vlookup formula rather using two times vlookup???

Thank you for this, I can't tell you how frustrated I was with my formula because it wasn't working. This method made it so much easier for me.

Sir please make a same video if employee repeated twice

Thank you Syed. I was so silly i have been sorting data manually 😂 and it was draining me. I asked Chat GPT it gave me Vlookup and watched your video to help understand better.

Hello Sir, Good Morning.
I understood this, but I have a query, considering one cell value, I want to pull all the row values at once
By entering "Yes" to provide all single row data in one stretch, if "No" means not to pull the row data and have to skip for next. Kindly need your help on this.

"Scenario is CRM data. With common database with multiple CRMs."
Consider

Thank you

Thank you. This was very helpful.

😍

this is very helpful, i used to hesitate to ask my colleagues everytime to help me with vlookup, but now my problem is solved

First video in my life where the work book is also given for practice.. Thank you so much.

I used to think Vlookup is tough, after watching this video I'm amazed how easy it is and really helped me. Thank you so much brother

Thank you so much for this video and also for the practice workbooks.

Am I the only one who still couldn't figure it out? 🙁

Hi i am not able to fetch with vlook the email Id on shared workbook under see it as discussed on the video . Kindly share the formula to fetch email ID

Good Lesson. Great Men.

Dude I swear Vlookups hate me. I do all of this in my project and it still returns NAs... Is there something with like the order of the columns or something?

This is not working

This was really, really helpful and I'm immensely grateful.
I especially appreciate the time you took to call out in the vLookup formula what the elements of the formula are doing, what they're referencing. It really helps to solidify it in my mind. Oh, and supplying us with some data sets to practice with? Absolutely wonderful.
Thanks again.

Thank you for this, is there a way that i can combine the two formulas into one and drag it from name & email without entering the formula twice?

Perfect sir ❤️

Thank you sir this is truly amazing, I got a question, can we make 1 single sheet using v look up from different workbooks ?

excel has never been this interesting to learn about

What if my data is not in order but i still need exact match like in previous sheet my name is in top but in another sheet its in middle but I don’t want to sort by doing ascending order. How can we find data

how to put vlookup from 3 sheets in single column, for example, we have to get salary, from different departments, into master sheet, where all employees are listed.. Salary column to be updated from 3 different sheets

May God bless you beyond measures, you just saved me from receiving query from my supervisor.

Sir how do I enable vlookup between 2 workbooks? I'm not getting this option.

Absolute Legend! Champion

Thank you 🙏🏼

Thanks.

Good explanation

Excellent

Thank you for explaining, in non-programmer language how to do this! I really appreciate it and am now a subscriber!

Great concise tutorial... thank you.

Thank you sir,,🙏

Extremely easy , thanks man!

want to use trim

How to get dynamic values using different workbook

For example first workbook contains list of vegetables and fruits, the price changes every day. In the second workbook it has to calculate the total purchase value for each customer

thank you

you are the champ. straight to the point and no BS like others who just want to waste their as well as our time

Thanks so much, preparing for an interview and this just made me feel much comfort.

excellent tutorial, many thanks Syed

Thank you Sir