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

365 Data Science
Published at : 06 Nov 2021
18203 views
144
6

👉🏻 FREE MONTH! Get full access to our newly redesigned platform and all our courses (18th October - 18th November): https://bit.ly/2Y0i7e8

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

► Consider hitting the SUBSCRIBE button if you LIKE the content: https://www.youtube.com/c/365DataScience?sub_confirmation=1

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.

Check out our Data Science Career guides: https://www.youtube.com/playlist?list=PLaFfQroTgZnyQFq4nUfb-w2vEopN3ULMb

#INDIRECT #Excel #Function