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.
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.
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?
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.
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?
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
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.
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!
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?
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?
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!!
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
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.
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!
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.
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 ruclips.net/video/ljvB2arCsNQ/видео.html
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
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
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)
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
This was very easy to follow. Saved me a lot of time. Thank you!
Thank you for the great walk through. This worked exactly as expected for my different tabs.
You're the MAN. Thank you for the easy to follow instructions on this topic.
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!
Damn, this video is a life saver. Thank you so much
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!
This help me so much... thanks man!
I was able to follow you and got the correct results.. thank you so much !
This was brilliant! Thank you for this video. It got me unstuck!
Explained very systematically. Great Job . Thanks 🙏
Glad it was helpful!
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.
Very clear and useful video !
Running VLOOKUP from other files is really cumbersome! Excel is so much more practical than Google Sheets...
This is really helpful. Thanks.
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!
I actually got what I wanted in 2 minutes, Thanks for the great video :)
:)
Superbly Helpful brother!! This is incredible! So many Thanks!🙏🙏🙏
One word for you..Awesome 👌 👏 👍 😍 💖 🆒️
This was very helpful. Thank you!
Amazing... You're the best 👌
Great explanation! Thank you it helped me a lot.
Thank you!!
So helpful!
thanks for doing this extra vlookup.
Thank you!
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.
Useful video for multiple sheet vlookup formula
Thanks!
Thank you. this was very useful
Thanks
Nice work
Excellent video!
great thanks!!!
OMGTHISISAWESOME!!!!
Thanks!
1st - I send you like then watch 😀thx for your videos!
Yay! Thank you!
Thank you so much,
Thanks, you saved my day!
👍
Interesting Vlookup, always efficient ....So can I get this file for practice...
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.
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?
Thank you so much for this informative video!!!
May I know how to hide certain columns based on the dropdown value?
Awesome,very useful.
Thanks!
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.
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.
Extremely useful 🤗
Thanks
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?
Thanks for your video, it’s very useful!
Glad it was helpful!
nem sei como agradecer!
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
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.
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!
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 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.
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?
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.
Is there a limit to how many tabs you can string together?
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?
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.
i like it
Thank You!
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 very helpful does it work on Microsoft 365
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.
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 for this video, how to make vlookup from different sheets with different column? in your case you searching in column 2
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.
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.
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 ruclips.net/video/ljvB2arCsNQ/видео.html
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 ruclips.net/video/_MDOYvErfyg/видео.html
Why is it there is no allow access here in my file sir?
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.
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)
This is not working, when using the {}, error msg pops up "is this not a formula". Help me pls in resolving this issue.
Its not working with App version, you are showing this formula in web version, do you have any formula for app version?
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
Not working