VLOOKUP into another Workbook (Google Sheets)

How to VLOOKUP from another Workbook in Google Sheets is explained in this video.
🍐Join my online course on Excel Tables
www.udemy.com/...
🍓Download my free eBook on Excel Macros
eepurl.com/gpT0RD
🍇Check these Books on Excel
xlncad.com/exc...
🍉Read my articles on Excel
xlncad.com/
🍏Playlist for Shorts on Excel
• Short videos on Excel ...
#googlesheets #googlesheetstutorial #googlesheetstips

[@eldoradotools]

Best explanation I have found. My problem was solved in two seconds, thank you!

[@AjayAnandXLnCAD]

My pleasure 😀

[@aneeshipcs]

thanks, really helped ! its totally different from how its done on excel sheet

[@CyborgDanX]

Saved my life! Kudos for the video bro.

[@yumyum6386]

This is very useful. New to your channel and hoping to learn more google Sheets functions. Thanks!

[@xyclos]

Worked perfectly!!!Thanks a lot Ajay!

[@PeteCorp]

Thank you.

[@Cosmicbroindaavd]

Good tutorial, thanks for sharing

[@AjayAnandXLnCAD]

You're welcome

[@flybmxer89]

Thank you!! I searched a few tutorials and couldn't figure it out until I came across this

[@thulasipraasad]

THANK U SIR

[@elsastallone9197]

thank you for such simple and understandable explanation

[@AjayAnandXLnCAD]

My pleasure 😀

[@xkatiekapowx]

This is awesome thank you

[@MindMassageEntertainment]

You Rock! Thank you vry much!!!

[@Romariowll]

Hi Master, there a way to do that with two criteria? Like Search the name and Date? Two itens

[@Mahesh-d1x]

Thank you sir
I got v lookup from you ❤

[@AjayAnandXLnCAD]

My pleasure 😀

[@AjayAnandXLnCAD]

My pleasure 😀

[@neeshespieces]

Thank you so much this video was a blessing!!! THANK YOU AJAY

[@AjayAnandXLnCAD]

My pleasure 😀

[@sevenyays]

Great video - thank you 👏

[@AjayAnandXLnCAD]

My pleasure 😀

[@indianhistory_tales]

thanks for your tips It is very helpful for me

[@nandana3066]

4:42 is there a way to copy the codes to the cells below without dragging?

[@ashishbhatia2448]

thank you so much 🙏🏻

[@AjayAnandXLnCAD]

My pleasure 😀

[@sjpdefault]

Please make more videos for Google Sheets Functions🤩

[@mhowardwhitaker]

I have 2 worksheets both full of data. I want to see if a certain employee’s information is in the second sheet. How do I do that?

[@majidsaeed]

Hello Ajay. What if the Employee ID column was a drop down list?

[@fahadwajid1699]

Thanks Sir

[@GurukrupaIndustries-iv4kh]

Thank you...problem solved

[@AjayAnandXLnCAD]

My pleasure 😀

[@ChiminBlue]

What if the REF1/Sheet1 is a continuous row/range? what should I write instead of like "Sheet1!B3:H65"? I mean the 65 rows will increase at the Sheet1.

[@bernardsco7663]

Thanks a lot

[@VincentEkeoma]

this is helpful

[@velmurugan2841]

Thanks 😊

[@harisubangkit7866]

what if the responses in cell we want to fill say "adding permission" but nothing happen after?

[@arjunprajapati2123]

Thanks

[@ALMUKHTARROYAL-n9n]

I am doing the same but data show loading from last one week, not loaded yet, what should be the mistake or error? how can I solve data loading timing error?

[@Vikas-qr7oz]

Same problem

[@AyazKhan-z5r]

100% Working method

[@ramuachari1036]

Really it's working?

[@EricaSandler-g7t]

Hi, I need help please. I'm trying the lookup function but I get an error stating I don't have permission to access the spreadsheet although it is my own sheet in my drive and not shared with no-one else.

[@mardiegardner6977]

I am having the same issue. I do not have the button to request access.

[@LysRojas]

Same issue here

[@IanDeLaFuente-u7s]

Mine doesn't say allow access. What to do?

[@NitinDubey-h8m]

Instead of writing false put 0 and try

[@DenisseGonzalez-j8c]

I wasted too much time in spanish tutorials, I don't know why latins can't go straight to the point. Gracias!!

[@rubabatulurba6662]

but it still gives error (N/A) when i try to pull from the same excel having two sheets

[@geneovarb7255]

Dont follow the formula in this vid if your working on 2 or 3 or many sheets with same workbook, you can use simple steps only to fetch data from sheet to sheet on same workbook.
As the vids says Vlookup from "workbook to another workbook." it means another excel file.

[@ruthasonye5655]

Mine just shows error

[@Nname-ou3gu]

Excited to be hired at your company, I would like to interview with Mr. Ryan Reynolds

[@EngelinaRatshibaya]

Its not working on the data i have

[@marievicibayan54]

how about xlookup funtion into another workbook (google sheets also)