VLOOKUP into another Workbook (Google Sheets)

[@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.

[@flybmxer89]

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

[@nandana3066]

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

[@elsastallone9197]

thank you for such simple and understandable explanation

[@AjayAnandXLnCAD]

My pleasure 😀

[@Mahesh-d1x]

Thank you sir
I got v lookup from you ❤

[@AjayAnandXLnCAD]

My pleasure 😀

[@AjayAnandXLnCAD]

My pleasure 😀

[@Romariowll]

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

[@sevenyays]

Great video - thank you 👏

[@AjayAnandXLnCAD]

My pleasure 😀

[@majidsaeed]

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

[@neeshespieces]

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

[@AjayAnandXLnCAD]

My pleasure 😀

[@SairylJanePadayao]

Please make more videos for Google Sheets Functions🤩

[@indianhistory_tales]

thanks for your tips It is very helpful for me

[@ashishbhatia2448]

thank you so much 🙏🏻

[@AjayAnandXLnCAD]

My pleasure 😀

[@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?

[@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.

[@GurukrupaIndustries-iv4kh]

Thank you...problem solved

[@AjayAnandXLnCAD]

My pleasure 😀

[@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

[@harisubangkit7866]

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

[@IanDeLaFuente-u7s]

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

[@fahadwajid1699]

Thanks Sir

[@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

[@bernardsco7663]

Thanks a lot

[@VincentEkeoma]

this is helpful

[@DenisseGonzalez-j8c]

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

[@velmurugan2841]

Thanks 😊

[@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.

[@Nname-ou3gu]

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

[@marievicibayan54]

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

[@arjunprajapati2123]

Thanks

[@AyazKhan-z5r]

100% Working method

[@ramuachari1036]

Really it's working?

[@EngelinaRatshibaya]

Its not working on the data i have

[@ruthasonye5655]

Mine just shows error