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.
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.
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!
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.
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.
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?
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?
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
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
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 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!!
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)
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 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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ljvB2arCsNQ.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
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