VLOOKUP from Multiple Worksheets (Tabs, Sheets) or Spreadsheets (Files) - Google Sheets

Learn how to do a VLOOKUP from multiple worksheets (tabs, sheets) or spreadsheets (files, Google Sheets).

#vlookup

[fabionave]

Running VLOOKUP from other files is really cumbersome! Excel is so much more practical than Google Sheets...

[josephcheriah]

I can't thank you enough for this video. You just saved my life. I already spent 2 weeks researching google to find this answer, but thank God for this video. This is very helpful!!!

[anamayoca]

THANK YOU FOR THIS! It really helped a lot! ☺

[swadeshdiary]

Useful video for multiple sheet vlookup formula

[chris-oo-]

Awesome Bro, you are now my Google sheet Master :) peace

[expectationsvsreality]

One word for you..Awesome 👌 👏 👍 😍 💖 🆒️

[joenkhula]

Simple and concise 👍 ... Simply amazing! :)

[jamesjenningsix]

You're the MAN. Thank you for the easy to follow instructions on this topic.

[sasha-leekinnear-ocon]

Thank you taking the time to make this video. I've watched so many videos regarding this topic and I just could not understand what to do, you explanation is simple and to the point. Thank you!

[ClaudeBowlding-WPMAA]

I was able to follow you and got the correct results.. thank you so much !

[akassebaum]

This was brilliant! Thank you for this video. It got me unstuck!

[ClosertoSelf]

Superbly Helpful brother!! This is incredible! So many Thanks!🙏🙏🙏

[olympiasmith]

Great, thank you. I just want to add to make certain that your search key font and range font is the same or your return will be #n/a even though the number values look the same.

[Caldun-bnmi]

Great explanation! Thank you it helped me a lot.

[Uzomay]

Damn, this video is a life saver. Thank you so much

[byharry]

I actually got what I wanted in 2 minutes, Thanks for the great video :)

[katserest]

This was very easy to follow. Saved me a lot of time. Thank you!

[Ritawealthtrade]

Great Video. Thank you so much for clarifying where to get the index specifically, the index must be within the selected range. Not knowing this was a challenge for me. It kept saying 'out of range until I watched your video. Thanks once again. I have subscribed to continue learning google spreadsheets.

[Latz]

I have a table (GOOGLE SHEETS) that uses an array formula and a VLOOKUP to calculate and post scores in a golf tournament. I use IMPORT HTML from ESPN to obtain in a Table the field of entries and their respective scores. The first day it works perfectly. The second day the (HTML) ESPN site inserts in a row about 2/3 down “the projected cut line”. This blows up my form (#N/A results) and VLOOKUP Table. I can’t edit the HTML table to ignore the inserted row or can I (it updates the tournament scores every 5 minutes)? Or can I modify the range in the Array/VLOOKUP formula to ignore the inserted row? If so, how? Looking for any suggestions.

[morpheus]

Thank you so much for this informative video!!!
May I know how to hide certain columns based on the dropdown value?