Becausesee, sixisnot a textstring, andhencethefunctioncan't provide a result.
Lookathowtheresultchanges.
If I play, seesixwithininvertedcommas, See, andwhydiditwork?
Becauseputting C sixininvertedcommasmakesindirectReadthecellas a textstringindirectsimplyreturnstheinformationcontainedinthereferencewe'vespecifiedastexthere.
Itgivesusthenumbercontainedin C six.
Analternativewayofincluding C sixas a textstringistohavetheletter C ininvertedcommas.
AndthenKhancaptainateitwiththenumbersix.
Thisway, Excelwillreaditas a textstringandyoucanobtainananswer.
Andthetrickhereisif I changethenumberwithinthefunction, itsresultswillchangeaswell.
If I modifytheletter, theoutcomewillbedifferent.
Andthisisveryimportant.
You'llseewhyin a second.
Sothisisthefirstthingtorememberaboutindirect.
Aslongasthecontentbetweenparenthesesistextsforming a cellreferencethefunction.
We'llgetyouthere.
Allright.
Excellent.
Let's moveontothenextsheet.
Now I willshowyouhowtocombine V lookupandindirect.
Herewehave a differenttablewhichprovidesinformationabouttheannualsalaryofemployees.
What I wouldlikeis a smalltableshowingthenumberofemployeesandsalariesofmanagementandthestaffofcompany D.
So I'llstartbytyping V.
Lookup.
Thelookofvaluewillbemanagement.
Thisreferencemustnotchange.
When I draggedtheformulatotherightso I'llfixthecolumn.