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

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
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 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
in cell O10 in the valuable worksheet, enter a database function to count the number of art pieces where the comment in Highly valuable. the criteria range is located in the range N6:N7
Solved by T. A. in 18 mins