 # Get instant live expert help on I need help with range function 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

I am facing an issue with excel offset function for a range which increases horizontally and vertically. I need help with creating Horizontal and Vertical Offset function for a dynamic range
Solved by A. A. in 27 mins
In cell H11, add a MAX function that will show the maximum call length minutes using the Call_Length named range and in cell H12, add an INDEX function that will use the Dept named range as the array associated with a MATCH function to determine the lookup array for the longest call referenced in H11 from the Call_Length named range with an exact match.
Solved by V. J. in 18 mins
In cell H12, add an INDEX function that will use the Dept named range as the array associated with a MATCH function to determine the lookup array for the longest call referenced in H11 from the Call_Length named range with an exact match. In cell H13, add an INDEX function that will pull the satisfaction rating associated with a MATCH function to determine the lookup array for the longest call referenced in H11 from the Call_Length range with an exact match.
Solved by C. Y. in 24 mins
can you explain why in the sales worksheet, vlookup function in column E range lookup is 0 while in column H the range lookup is true. what's the difference?
Solved by X. D. in 22 mins
In cell E11, enter a financial function to calculate the interest paid. Copy the formula to the range E12:E34. The result should be a positive value. In cell F11, enter a financial function to calculate the principal payment. Copy the function to the range F12:F34. The result should be a positive value. In cell G11, enter a formula to calculate the ending balance. Copy the formula to the range G12:G34. Adjust the width of column G, if needed, to display the values. Select the range D11:G34 and apply Accounting Number Format.
Solved by V. S. in 16 mins