Get instant live expert help on match function in r

“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 need to lock a table reference in an index, match function. E.g. =INDEX(R[241]C[-8]:R[377]C[-5],MATCH(RC[-8],R[241]C[-8]:R[377]C[-8],0)+0,4) I do not want to change R[241]C[-8]:R[377]C[-5] or R[241]C[-8]:R[377]C[-8] when I drag the formula down
Solved by X. H. in 23 mins
Solved by T. D. in 18 mins
Hi, I want to create a countdown to show when I go on R&R from work in Iraq. So far I have created a pie chart and separate data that shows how long I have been in country for and also how long I have left until I go on R&R using the required formulas and dates that says when I arrived in country and when I go on R&R. I would like to a function to this that shows when I have less than a month to go for R&R, with the text appearing below the pie chart stating "Less than a Month" when I have reached this time frame, and also I would like the same for when I reach a week or less. Was wondering if you could help on the matter please?
Solved by C. C. in 26 mins
Type in the R square of my model ( Hint: R square after first iteration) ?
Solved by A. L. in 20 mins
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 I. W. in 16 mins