Indirect - Google Sheets & Excel - Basic Use and Using Function with Multiple Sheets

Learn how to use INDIRECT function in Google Sheets & Excel. In this tutorial we'll cover fundamentals and go over examples using INDIRECT function with multiple sheets using concatenation.
#indirect #googlesheets #excel

[@lpanebr]

I really like indirect and use it a lot. One important thing to point out though is that when you insert columns, rows etc the concatenated string ranges need to be manually updated.

[@nurlasmini]

Really good video, thanks for sharing👍👍👍

[@bstrykHHO]

Finally!! Thank you for a great explanation. I’ve seen many other videos, but none of them explained it as well. Thank you!

[@lty2610]

Very clear and useful video, thanks~

[@ghyathalmograbi3361]

very nice and simple way of explanation , thank you ,, it means we use indirect when we want Transfered the text to reference it is very accurate ,,,

[@ksskoala4446]

Very well explained; thank you!

[@sbhanuprakash9]

You are a genius! I was struggling for an option like this to take the sheet name automatically. Finally I go it. Appreciate you knowledge sharing.

[@ninjapage]

do you provide access to your workbooks for practice??

[@malikastar9265]

That was clearly explained, and very helpful, thank you

[@ExcelGoogleSheets]

👍

[@vishaleee404]

great explanation sir. thank you thank you so much from india.

[@martinachoi7843]

Wow it is so helpful. Appreciate your videos!

[@ManojGuptahome]

This is great explanation. I learn a lot of things from your videos and it drives me to do do more. Presently I am stuck with INDIRECT being used with VLOOKUP and IFERROR. I know you warned against using INDIRECT with other formulas but is there a simpler way. My problem is lookup array of different month sheets and summarizing, while leaving blank when the sheet is not there. My formula is =IFERROR(VLOOKUP($C$2,INDIRECT($A25&"!$j$2:$l$15"),3,FALSE),""). Where C2 has a category in sheet A25 and J2:J15 is the lookup table in each sheet. The preview gives the correct value but it is not updated automatically.

[@lazalazarevic6192]

Cool explanation. Thanks

[@hanglam8571]

Excellent! Thanks

[@wojciechorama]

EXACTLY WHAT I NEEED happy new year

[@ExcelGoogleSheets]

👍

[@mdz-ro]

exactly what I needed, you explained extremely well love you😍

[@ExcelGoogleSheets]

👍

[@abhijithcmr]

Great. But is it possible to use this method with ArrayFormula?

[@oOoScarecrow31oOo]

I'm struggling with INDIRECT using it in the FILTER() fonction ! 😩

[@SnowHunter44]

solved my problem - thanks

[@golammusabbir914]

hoooooo... thats amazing... thank u for introducing this unknown useful function.. u r just great

[@azad89100]

INCREDIBLE, this would really help me to save time and energy, I had searched up a lot without finding such amazing tutorial video ..

[@flambert57]

How can i get spreadsheet name in the formulas directory Grom.the label of the sheet? ( whithout go in the scripts proprty and methods)

[@hemantsonawane153]

awesome

[@ExcelGoogleSheets]

Thanks!

[@RobertLongM]

Always great teaching - - CHALLENGE I can't figure out is using INDIRECT withing an API/URL

[@ExcelGoogleSheets]

What you mean?

[@RobertLongM]

Learn Google Spreadsheets Are used your JSON import. But the URL has a date in it. And I wanted to create a drop down that I can adjust the date in the URLAPI

[@ExcelGoogleSheets]

What does this have to do with indirect? Please share an example sheet of what you tried?

[@RobertLongM]

@@ExcelGoogleSheets Take the =ImportJSON() Inside that o have in the URL a /2019/") I want to use Indirect to have the year be a cell reference. Can't seem to get the syntax right

[@ExcelGoogleSheets]

You don't need indirect. You need to just concatenate. kzbin.info/www/bejne/oYPRn6ekrrmafLc

[@DILEEPKUMAR-is1vi]

Awesome

[@AlexSmith1]

Very useful. Thank you.

[@eastonnewman1868]

Very useful skill, thank you!

[@sergeantseven4240]

I'm trying to figure out how to populate cells on a sheet where the drop down list is with the information for both being on a separate sheet. I've got the drop down list populate based on the range of data from the other sheet but I can't figure out how to populate the rest of the data in to the cells based on what is selected in the drop down.

[@annariddick976]

How did you do that drag thing? Where you selected the top and dragged it down and the formula copied but for the other sheets?

[@hoiyinwan8233]

Indirect function is so useful, but it is so hard to find explanation. I use this function alot!!

[@aprendendogooglesheets8040]

You ara a GENIUS!!!

[@ExcelGoogleSheets]

:)

[@raulbezerra1929]

I already have an ideia for how its gonna be usefull for me, thanks!!

[@yungkuan1260]

Is it possible to use Indirect for the Range_string of importrange? I am getting an error when attempting

[@pravinghanesh]

Thank you so much.

[@phecube]

how do you use indirect with actual quotation marks in the formula? “ “

[@jamesantonywhitehead2814]

Why did you not add the year to the formula in colum I ???

[@raulbezerra1929]

Man i really nedd help about something: Is it possible to combine Indirect function with Arrayformula? Like: Arrayformula(Indirect(...))?

[@ayahoo16]

It does not seem to be. I have been trying to do just that for 3 days with no luck. Granted I am not a pro by any means but it does not seem to work. If you figure it out please let me know, but I have given up and I'm just going to drag my indirect functions.

[@abhijithcmr]

@@ayahoo16 Am in search of the same for the past 2 days. Any of you got any solutions? please let me know....

[@fttx6673]

I'm looking for the repetition of each line in the list, but I couldn't find it

[@NewToneProducer]

At 9:58, you explain how you can't use INDIRECT within another function. That's exactly what I'm hoping to do. Is there a way to do something like this without using INDIRECT? I'm trying to do a countif in different tabs, but it's a pain to update each row manually to reflect a different tab to reference. Would be nice if I could have it reference the tab name that is listed in a column.

[@GV-gn3mj]

Thank you. It is really complex, how the H column reference a tab with a different name? because the tab is product 2105 etc but the column H is just 2015, also what is doing the exclamation sign there?

[@ExcelGoogleSheets]

You should watch this kzbin.info/www/bejne/o4W6mWaMhZt7hs0 and this kzbin.info/www/bejne/oYPRn6ekrrmafLc

[@MuhammadIbrahim-zc1vx]

Neatly explained

[@SamEslamiehBISM]

Great video, but I had difficulty using indirect building a query data from multiple sheets

[@attilahuszar2028]

I have two different questions: 1. Can we write indirect function in the query data range??? 2. Can use a range the indirect function? For example: =INDIREKT{'1'!A1:B; '2'!A1:B} ets. It doasn't work for me.

Thank You.

[@louaimoghrabi]

Super! Thank you soooo much

[@darlalandaal1061]

Thank you for this training, it has been a great help! I do have an issue that I am sure you can help with. I have a formula =IFERROR(INDIRECT("'"&$B3&"'!$B$3"),"") However, when I have B3 filled in on my worksheet, it works fine. When I copy down the formula it pulls the information from the same worksheet. Not sure what I am doing wrong. Thank you for the assistance.

[@andresrcastilloh2454]

Solved Thanks!!!

[@pipeliner8969]

great I needed this

[@walterpaiva719]

Thanks for the video!! I really enjoy watching your videos ;]

[@pichit.raetai]

Thank you

[@cuneiformscript2665]

🙏🏻