Get instant live expert help on I need help with using indirect in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Need help wtih data retrieval using offset and indirect
Solved by E. E. in 18 mins
Can not find #REF error start in my Google sheets when using Indirect Concatnate :(
Solved by K. L. in 28 mins
Hello, I need help regarding indirect formula of excel. 1. What is the purpose of using this formula? 2. If we use this formula with sum formula, then why we are using this with sum formula, we can also perform addition from different sheets without indirect formula ?
Solved by O. D. in 25 mins
Hi Can you assist, I am using a countif formula and want to include indirect to count the number of "P" between 2 dates. I have this formula working but cant seem to get to work using indirect as get #value I want to use indirect as I have several similar sheets and just want 1 summary page. Working formula not using indirect =COUNTIFS(Sample!6:6,">="&B5,Sample!6:6,"<="&C5,Sample!8:8,"="&I7) Non working formula using indirect =COUNTIF(INDIRECT("'"&$G$2&"'!"&$C6,">="&B5),(INDIRECT("'"&$G$2&"'!"&$C6,"<="&C5),(INDIRECT("'"&$G$2&"'!"&$C8),I$7))) G2=Sheetname which one is called sample C6=6:6 C8=8:8 B5=From date B6=To date I7=P Thanks Matt
Solved by G. U. in 25 mins
Could you please explain what is being referenced in the follow string? I am familiar with using INDIRECT and CONCATENATE together. =INDIRECT(CONCATENATE("'Sheet Name'!",K$1&$A6))
Solved by B. L. in 24 mins