AboutPricing

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.
< Go Back

    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