How to use INDIRECT Function | Excel in Hindi

[@deepu03393]

excel super star is now rocking star👍👌

[@reehanskt682]

Rishabh, your all videos regarding Excel .Superb.

[@pradeepjangid490]

U r really excel superstar. Sir, u deserve Microsoft.

[@ExcelSuperstar]

Thank you so much 😀

[@canirmalchoudhary8173]

Indirect rarely used but if used no easy than it. I used to fetch table table data, where filter goes to Indirect to fetch table data. FILTER(RANGE, INDIRECT(TABLE)&COLUMN 2) Generally it is useful when you want to change input in the formula which is taken from a cell which itself redirect to some kind of range/data. In short INDIRECT is a formula which leads you to the data thru a cell which contain address to that...Like if we don't hardcode the table name in the formula then we have to use INDIRECT formula

[@munishsharma1704]

Rishabh, you are just Awesome..Thanks a lot

[@jitubaheti4233]

It's so commendable for your simplified explanation 👌

[@umeshmishra2010]

amazing example is being delivered sir. extraordinary

[@virendrahardiya2797]

Wao Sir I was searching this trick before some days.

[@SHEERAZ-ALI]

Sir ji u r really Excel Superstar

[@sisirmcops]

Please make a video of Gantt chart

[@debanjanmukherjee811]

Hi Rishav, ca. U pls show some real life usage?

[@sarbanidas5669]

is there available any live classes ?

[@zkgconnect7624]

Excellent

[@piarchanddogra1659]

Superb👍

[@umeshbanchhor6875]

अलग अलग सीरिज के रोल नंबर से Room wise seating plan

[@umeshbanchhor6875]

Kaise banaye क्रृपया बताईए ।

[@ashwajitthukral9101]

super

[@Mr.khan7000]

Woww sir !!! You are a genius 🌹💞🌹 I have never seen any formula like this before. Wese sir maine aapse ek question poocha tha uska answer nahi mila, Agar "Tabish 12378 Madhya Pradesh" is tarha k data me se sirf number alag karna ho ya fir text alag karna ho to formula se kaise karege ??? (Office 2007 me)

[@maqbool1682]

Nice

[@SHEERAZ-ALI]

Sir ji Xlookup pe kab video aa rahi hy

[@dineshkushwah1368]

👏👏👏

[@chaitanyakulkarni2090]

Show vlookup+indirect

[@shaheenshaheensks5696]

Sir rank Ka mala heee

[@saahilsaahil5912]

=indirect ("'"&$A4&"'!d3:d3") sir Maine ye formula aaply kiya hai data extract krne from other sheet.. but sir other columns mein jab formula drag krna chahata hoon toh nhi horaha plssss sir kindly guide me.. mjhe har column bar bar formula lagana pardhra I want to drag it at once

[@meeramishra626]

I don't know why, but naming the range as list and using in indirect("list") is not working... Excel 2016

[@hemlatasharma2082]

Bht complicate h sir