INDIRECT Excel Function: How it works and when to use it [Advanced Excel]

In this video we'll learn how to use another interesting Excel function indirect in addition. We'll see how it can be applied in combination with vlookup. Previously we've said it is common practice to use cell references in formulas and indirect. If implemented properly it can be helpful when working with cell references.

Please follow this lecture carefully to understand how indirect functions. It can be tricky but don't worry, we are here for you! Indirect returns the reference indicated by a text string so the input we should have in the brackets must be a text string. What do I mean by that I suppose was interested in the precise number of staff employees working in a company and I wanted to obtain that number by using indirect in other words. I am interested in the number written in cell c6. Right, let's see what happens if I select cell c6 as the input of the function Excel displays an error message. Why? Because c6 is not a text string and hence the function can't provide a result look at how the result changes if I place C 6 within inverted commas

365 Data Science is an online educational career website that offers the incredible opportunity to find your way into the data science world no matter your previous knowledge and experience. We have prepared numerous courses that suit the needs of aspiring BI analysts, Data analysts and Data scientists.

We at 365 Data Science are committed educators who believe that curiosity should not be hindered by inability to access good learning resources. This is why we focus all our efforts on creating high-quality educational content which anyone can access online.

#INDIRECT #Excel #Function

[wildwestgunslinger]

Very nice trick, i find this to be really cool

[happymm]

Thank you! This is a great tutorial to learn "Dynamic lookup table" and indirect & vlookup function. Your example is great!

[MrAravindh]

Thank you so much
You just saved my day!!!

[tranduy]

Man, this is the best visual explanation of this matter. Thank you.

[mikelennon]

Can you use this function in CRM ( One to Many) . i.e. I have several worksheets. One is the records of many Customers ( Companies), the second Contacts ( All employees who are working in each Company), third Invoice records. Each company may have zero to 100 invoices, forth sheet for all work orders (Each company may have zero to 100). The using Data Validation and Combo Box to select a company in a new sheet and upon doing this to see certain columns from other sheets. ( Name, Title, Email & Phone of its contacts), (Date, Invoice Number, Product, Value, ..) from Invoices, same goes for Work orders and any other sheets. I would appreciate your input. Thank you

[cosmicpurp]

I don’t understand what the point of this function is. Why wouldnt I just use indexmatch?