VLOOKUP into another Workbook (Google Sheets)

preview_player
Показать описание
How to VLOOKUP from another Workbook in Google Sheets is explained in this video.

🍐Join my online course on Excel Tables

🍓Download my free eBook on Excel Macros

🍇Check these Books on Excel

🍉Read my articles on Excel

🍏Playlist for Shorts on Excel

#googlesheets #googlesheetstutorial #googlesheetstips
Рекомендации по теме
Комментарии
Автор

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

eldoradotools
Автор

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

flybmxer
Автор

Saved my life! Kudos for the video bro.

CyborgDanX
Автор

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

nandana
Автор

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

yumyum
Автор

thank you for such simple and understandable explanation

elsastallone
Автор

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

Romariowll
Автор

Thank you sir
I got v lookup from you ❤

Mahesh-dx
Автор

thanks for your tips It is very helpful for me

indianhistory_tales
Автор

Please make more videos for Google Sheets Functions🤩

SairylJanePadayao
Автор

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

neeshespieces
Автор

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?

mhowardwhitaker
Автор

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

majidsaeed
Автор

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.

ChiminBlue
Автор

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

harisubangkit
Автор

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

IanDeLaFuente-us
Автор

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.

EricaSandler-gt
Автор

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?

ALMUKHTARROYAL-nn
Автор

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

rubabatulurba
Автор

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

DenisseGonzalez-jc