# Get instant live expert help on I need help with excel indirect example

“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

Excel help with offset/indirect functions
Solved by E. J. in 17 mins
=IF(\$C\$127="",VLOOKUP(B127,INDIRECT(\$B\$128),10,FALSE),INDEX(INDIRECT(\$B\$128),MATCH(1,(INDIRECT(\$B\$129)=\$B\$127)*(INDIRECT(\$B\$130)=\$C\$127),0),10)) shows me #N/A
Solved by M. H. in 20 mins
=SUMIFS(INDIRECT("\$C"&\$F1):INDIRECT("\$C"&\$F2),INDIRECT("\$C"&\$F1):INDIRECT("\$C"&\$F2),E\$3). E\$3 contains a specific condition of greater than only. How can this be changed to a range condition of less than and greater than.
Solved by K. D. in 16 mins
I need help on how to use indirect function along with sumifs function in excel.
Solved by Z. W. in 15 mins
I want to understand this formula and see where the source data is coming from =IF(ISERROR(VLOOKUP(\$A6,INDIRECT("'"&O\$1&"'!q:s"),3,0)-VLOOKUP(\$A6,INDIRECT("'"&O\$1&"'!q:s"),2,0)),0,VLOOKUP(\$A6,INDIRECT("'"&O\$1&"'!q:s"),3,0)-VLOOKUP(\$A6,INDIRECT("'"&O\$1&"'!q:s"),2,0))
Solved by S. A. in 19 mins