How to use INDIRECT Function | Excel in Hindi

[@deepu03393]

excel super star is now rocking star👍👌

[@virendrahardiya2797]

Wao Sir I was searching this trick before some days.

[@reehanskt682]

Rishabh, your all videos regarding Excel .Superb.

[@munishsharma1704]

Rishabh, you are just Awesome..Thanks a lot

[@SHEERAZ-ALI]

Sir ji u r really Excel Superstar

[@pradeepjangid490]

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

[@ExcelSuperstar]

Thank you so much 😀

[@umeshmishra2010]

amazing example is being delivered sir. extraordinary

[@jitubaheti4233]

It's so commendable for your simplified explanation 👌

[@piarchanddogra1659]

Superb👍

[@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

[@zkgconnect7624]

Excellent

[@saimkhan-tn5yl]

I am unable to fimd next video regarding this, can you please share the link here?

[@sisirmcops]

Please make a video of Gantt chart

[@ashwajitthukral9101]

super

[@debanjanmukherjee811]

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

[@maqbool1682]

Nice

[@sarbanidas5669]

is there available any live classes ?

[@umeshbanchhor6875]

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

[@umeshbanchhor6875]

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

[@dineshkushwah1368]

👏👏👏

[@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)

[@chaitanyakulkarni2090]

Show vlookup+indirect

[@SHEERAZ-ALI]

Sir ji Xlookup pe kab video aa rahi hy

[@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

[@shaheenshaheensks5696]

Sir rank Ka mala heee

[@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