Search for a value in another sheet in Google SHEETS (VLOOKUP + IMPORTRANGE)

In this tip, we will learn how to search for values in a different sheet in Google SHEETS with VLOOKUP ando IMPORTRANGE

➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions

➤You can also subscribe to the channel where you´ll find a new Sheets video every week.

Here are some of the places where you can follow and support me:

Any suggestion, question or insights, feel free to comment below

[stevenfoltz]

Any reason why when I use importrange on some sheets I get stuck with a loading error and other sheets it works fine? Only trying to move about 80 cells

[rhinoron]

I have tried several videos and yours was the one that made it possible for me to do vlookup from one spreadsheet to another. It took several tries but I finally was able to pause your video and follow the steps. Thank you for taking the time to do this.

[blessedkanu]

Hi new subscriber here, what if I'm trying to do this but the value I want is together with other values in a cell. For example: Sheet 1 has Facebook, Reddit(this is like the code column in your sheet, they are both in the same column but different rows) then next to it is(John, Anna, Kate), (John, Sarah, Ella). In Sheet 2, I want to type in John then bring in the social networks John uses, I want the data displayed the same way as yours. With John in a separate Column and The social networks he uses in Column B but with commas separating them.

[daveyoung]

Does vlookup still work? I'm trying to use it with a formula (A2, AA2:L, 12, 0) with A2 being a value of 62. The number 62 is in row 63 of Column AA, however the error code says that the number 62 was not in the range of vlookup. This data is actually in another tab, but I was getting the same error so I imported the data to this tab to see if vlookup worked better.

[abdullahquhtani]

Is there maximum records this way works before it fails. When using sql select it fails if records exceeds 50, 000 records.

[sumithraraghavan]

That was awesome! Thanks for such clear instructions! Saved my day.