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!!!
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!
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.
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.
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.
Thank you for all your videos. Your videos are my main source for all google sheets/scripts. Just a question if you also encountered an issue with query and importrange combination. I always get an error when i open the file for the first time. Always have to refresh to get it working.
Thanks for the videos, I've learned a lot. I've been using google sheets for a while now. I don't use libre office cause it's really slow. Numbers I have used in the past but not too familiar with it, seems like there's more and better documentation with Google sheets. My sheets are getting slow but I think because I have not taken the time to optimize my formulas or find out which formulas are better to use filter, query, vlookup etc... What do you think is the best way to optimize? Don't know if you already made a video for optimization. Seems like you have everything covered lol. Thanks.
I have a problem I need your guidance on. I'm using Google Forms to get inventory information. One Form Section "Adds Unit" with inputs: STOCK NUMBER, YEAR, MAKE, MODEL, NEW/USED, and LOCATION. The second Form Section "Updates Unit" and gets: STOCK NUMBER and LOCATION. My goal is to have a single up-to-date spreadsheet that the managers can look at to see which units are where. Google Forms are just an easy way to input data from our phones. Any help or direction is greatly appreciated!
Very nice example. Will the lookup work dynamically/always be updated? If not, is that possible in any way? Eg. using the importrange in a query function?
Hi, I am doing a report and the scenario is like, The tab names are the dates for reporting. How to make the tab names dynamic in this case, using Importrange?
I created the main document and the importrange formulas from 3 separate workbooks are all working great. However, when I make a copy of the main document, none of the formulas work anymore even though the formulas didn't change and it is not asking me to allow access for the new sheet. How do I copy the main document and keep all the connections to the original source documents?
How many importrange can we insert in our formula? I need to do the same thing but I have to import more than 60 sheets by now/ Do you think this is the best formula to use or you suggest to do someway else? Thank you so much!!
teria como entre duas planilhas a pesquisa acontecer em várias abas? No seu vídeo é de uma planilha para outra, mas a planilha que é consultado oferece apenas uma aba
When i move tabs it just doesn't keep the formula its so annoying, how do i fix i tried google for 2 hours now.. Edit: How do i do what you did at 1:09
Help! I am trying to use conditional formatting to highlight a cell that contains certain value in two different sheets . I am struggling with the formula, could someone please advise?
Dear sir, i need your help, I have 2 diff sheets and i want to highlights data with new entry if data is matching? if some one knows what i want please help me. Thanks
Thank you- what if I have 3 tabs/sheets and I want to not have the previous IDs on the preceding ones. Three separate files with all different - I need to pull out all the same IDs that might be on them. So tab 2 should not include IDs from tab 1 and tab 3 should not include any IDs from 1 or 2
GReat video. I tried it and for some reason only one of the ranges are showing. Not like in the video where it shows different info matching others. What could be the error?
If you're not under US locale then your syntax could be different. Check this video to understand what's different th-cam.com/video/ljvB2arCsNQ/w-d-xo.html
When I double click my VLOOKUP FORMULA it doesnt go like in the video where it auto fills up the rest of the row =VLOOKUP(A2,{'Free Consult Appts'!$G:$N},8,false) can i get help please ? thanks
First, let me tell you how much I appreciate your videos! You have taught me so much! I have tried using VLOOKUP and FILTER to get information from another tab to populate on a current tab and it is not working. A friend thought it may be because there is too much data - 21,233 rows and 10 columns. I have even tried to get rid of unnecessary columns thinking that might help. No luck! My formula is this: =VLOOKUP(F2,SDPBCFY20!A2:J,5,0). I know that does not help much without the spreadsheet. Any advice or help is greatly appreciated! Thanks - Melissa
I've tested Vlookup in a 54k rows x 33 columns sheet and it worked just fine. I know my answer might be irrelevant 9 months after your question, but it might be useful for someone else.
I always follow your vidoes. I have a different isse now though. I am using Apps script to create dynamic drop down, but if list goes beyond 500, it shows an error, "limit of 500. Ise the list from a range criteria instead". Pls suggest a workaround. Thanks
It only allows a list over 500 if you refer to a range in the spreadsheet, instead of comma separated values. Why would you have more than 500 possible options in a dropdown anyways? It seems to me like you should rethink the way you're doing data entry.
Hey Pls help me Error msg get when i use multiple sheet In ARRAY_LITERAL, an Array Literal was missing values for one or more rows. =VLOOKUP(F3,{'3O1'!A:L;'9XR'!A:L},2,0)
Hello, can you help me with this problem? I have a dataset that one column has tags, like: A B,C D,A C,D,B D How can I filter this like a list? A B C D Thanks in advance!
Awesome Bro, you are now my Google sheet Master :) peace
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!!!
Great to hear!
Running VLOOKUP from other files is really cumbersome! Excel is so much more practical than Google Sheets...
One word for you..Awesome 👌 👏 👍 😍 💖 🆒️
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!
Useful video for multiple sheet vlookup formula
Thanks!
You're the MAN. Thank you for the easy to follow instructions on this topic.
THANK YOU FOR THIS! It really helped a lot! ☺
Simple and concise 👍 ... Simply amazing! :)
Thanks!
I was able to follow you and got the correct results.. thank you so much !
Superbly Helpful brother!! This is incredible! So many Thanks!🙏🙏🙏
This was brilliant! Thank you for this video. It got me unstuck!
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.
This was very helpful. Thank you!
Amazing... You're the best 👌
This was very easy to follow. Saved me a lot of time. Thank you!
Thank you so much for this informative video!!!
May I know how to hide certain columns based on the dropdown value?
Great explanation! Thank you it helped me a lot.
thanks for doing this extra vlookup.
Damn, this video is a life saver. Thank you so much
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.
This saved me a lot. After a week of trial and error troubleshooting with the vlookup n/a, this solved it. Thank you.
Explained very systematically. Great Job . Thanks 🙏
Glad it was helpful!
Excellent video!
Thanks
Nice work
I actually got what I wanted in 2 minutes, Thanks for the great video :)
:)
1st - I send you like then watch 😀thx for your videos!
Yay! Thank you!
Thank you for the great walk through. This worked exactly as expected for my different tabs.
SUPER HELPFUL!!!! Thank you sir for sharing your knowledge.
"Arrayformula" will works to Vlookup+Multiple Sheet?
Sure
@@ExcelGoogleSheets may I know how? arrayformula works with Vlookup+Multiple Sheet?
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.
Its not working with App version, you are showing this formula in web version, do you have any formula for app version?
This help me so much... thanks man!
Interesting Vlookup, always efficient ....So can I get this file for practice...
Thanks, you saved my day!
👍
Thank you. this was very useful
Awesome,very useful.
Thanks!
Thank you for all your videos. Your videos are my main source for all google sheets/scripts.
Just a question if you also encountered an issue with query and importrange combination. I always get an error when i open the file for the first time. Always have to refresh to get it working.
Not usre. This sort of stuff happens with Google Sheets.
Very clear and useful video !
What happens if the ID you want to seach for is an drop down list? How can I link the data from the drop down list selected?
OMGTHISISAWESOME!!!!
This was so helpful! Can you advise on how to adjust the formula if the index value is different on each external sheet? Thanks so much!
Thanks for the videos, I've learned a lot. I've been using google sheets for a while now. I don't use libre office cause it's really slow. Numbers I have used in the past but not too familiar with it, seems like there's more and better documentation with Google sheets. My sheets are getting slow but I think because I have not taken the time to optimize my formulas or find out which formulas are better to use filter, query, vlookup etc... What do you think is the best way to optimize? Don't know if you already made a video for optimization. Seems like you have everything covered lol. Thanks.
Numbers is OK, lacking many features at the moment.
Optimization is complicated and every case is different.
@@ExcelGoogleSheets Thanks, yea I watched your video numbers vs Excel vs Google Sheets.
I have a problem I need your guidance on. I'm using Google Forms to get inventory information. One Form Section "Adds Unit" with inputs: STOCK NUMBER, YEAR, MAKE, MODEL, NEW/USED, and LOCATION. The second Form Section "Updates Unit" and gets: STOCK NUMBER and LOCATION.
My goal is to have a single up-to-date spreadsheet that the managers can look at to see which units are where. Google Forms are just an easy way to input data from our phones.
Any help or direction is greatly appreciated!
This is really helpful. Thanks.
thank you for this video, how to make vlookup from different sheets with different column? in your case you searching in column 2
Very nice example. Will the lookup work dynamically/always be updated? If not, is that possible in any way? Eg. using the importrange in a query function?
Yes, it will be updated.
Hi, I am doing a report and the scenario is like, The tab names are the dates for reporting. How to make the tab names dynamic in this case, using Importrange?
I created the main document and the importrange formulas from 3 separate workbooks are all working great. However, when I make a copy of the main document, none of the formulas work anymore even though the formulas didn't change and it is not asking me to allow access for the new sheet. How do I copy the main document and keep all the connections to the original source documents?
You can't. You need to do importrange formula separately to allow access again.
Hi, dunno if someone can help me but i need a tab that shows the current date values on another and all other sheets
Thank you!
How many importrange can we insert in our formula? I need to do the same thing but I have to import more than 60 sheets by now/ Do you think this is the best formula to use or you suggest to do someway else? Thank you so much!!
I think 50 is the limit. You can use 2 other spreadsheets in the middle and then pull your data from those.
thank you very helpful does it work on Microsoft 365
Is there a limitation on vlookup by number of rows?
Not that I know of. If you use an array instead of a range, there may be a limitation on the size of the array.
Extremely useful 🤗
Thanks
teria como entre duas planilhas a pesquisa acontecer em várias abas?
No seu vídeo é de uma planilha para outra, mas a planilha que é consultado oferece apenas uma aba
Is there a limit to how many tabs you can string together?
Thank you so much,
When i move tabs it just doesn't keep the formula its so annoying, how do i fix i tried google for 2 hours now..
Edit: How do i do what you did at 1:09
It's possible that your separator is ; instead of ,
@@ExcelGoogleSheets That worked! However still issues with picking the correct thing
Edit: Found the issue
great thanks!!!
Help!
I am trying to use conditional formatting to highlight a cell that contains certain value in two different sheets . I am struggling with the formula, could someone please advise?
Dear sir, i need your help, I have 2 diff sheets and i want to highlights data with new entry if data is matching? if some one knows what i want please help me. Thanks
I believe this is what you want th-cam.com/video/_MDOYvErfyg/w-d-xo.html
Thank you- what if I have 3 tabs/sheets and I want to not have the previous IDs on the preceding ones. Three separate files with all different - I need to pull out all the same IDs that might be on them. So tab 2 should not include IDs from tab 1 and tab 3 should not include any IDs from 1 or 2
Not sure I understand the questions.
GReat video. I tried it and for some reason only one of the ranges are showing. Not like in the video where it shows different info matching others. What could be the error?
If you're not under US locale then your syntax could be different. Check this video to understand what's different th-cam.com/video/ljvB2arCsNQ/w-d-xo.html
When I double click my VLOOKUP FORMULA it doesnt go like in the video where it auto fills up the rest of the row
=VLOOKUP(A2,{'Free Consult Appts'!$G:$N},8,false)
can i get help please ?
thanks
Just drag it down then.
So helpful!
Why is it there is no allow access here in my file sir?
Awesome video as always!
Would these arrays work if you made the ranges in the sheets as named ranges? Then you could just refer to the named range.
Yes I have the same question. Any answers to this?
First, let me tell you how much I appreciate your videos! You have taught me so much! I have tried using VLOOKUP and FILTER to get information from another tab to populate on a current tab and it is not working. A friend thought it may be because there is too much data - 21,233 rows and 10 columns. I have even tried to get rid of unnecessary columns thinking that might help. No luck! My formula is this: =VLOOKUP(F2,SDPBCFY20!A2:J,5,0). I know that does not help much without the spreadsheet. Any advice or help is greatly appreciated! Thanks - Melissa
I've tested Vlookup in a 54k rows x 33 columns sheet and it worked just fine.
I know my answer might be irrelevant 9 months after your question, but it might be useful for someone else.
for a data set that large youre better off using scripts to move data.
Thanks for your video, it’s very useful!
Glad it was helpful!
I always follow your vidoes. I have a different isse now though. I am using Apps script to create dynamic drop down, but if list goes beyond 500, it shows an error, "limit of 500. Ise the list from a range criteria instead". Pls suggest a workaround. Thanks
It only allows a list over 500 if you refer to a range in the spreadsheet, instead of comma separated values. Why would you have more than 500 possible options in a dropdown anyways? It seems to me like you should rethink the way you're doing data entry.
Hey Pls help me Error msg get when i use multiple sheet
In ARRAY_LITERAL, an Array Literal was missing values for one or more rows. =VLOOKUP(F3,{'3O1'!A:L;'9XR'!A:L},2,0)
Hello, can you help me with this problem?
I have a dataset that one column has tags, like:
A
B,C
D,A
C,D,B
D
How can I filter this like a list?
A
B
C
D
Thanks in advance!
Thank you!!
This is not working in normal excel spreadsheet. How to make it work in MS Excel spreadsheet
what's your formula?
This is not working, when using the {}, error msg pops up "is this not a formula". Help me pls in resolving this issue.
nem sei como agradecer!
i like it
Thank You!
Not working