Get instant live expert help on I need help with relative reference 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

In cell G5, reference the payoff date of the loan in B70. Be sure to use a relative reference to the cell containing the date.
Solved by B. F. in 13 mins
How can I reference cell data relative to the row from which the data is being pulled?
Solved by K. B. in 16 mins
How to fetch multiple relative position (horizontally) of a Reference cell value of Sheet2 into Sheet1; and as the reference cell value changes thus changes the formula.
Solved by X. W. in 19 mins
In cell C11, insert a relative reference to the loan amount in C4. In cell D11, insert an absolute reference to the monthly payment amount in G4. In cell G11, use relative references to add the values in cells C11 and F11. Select the range D11:G11, and then use the fill handle to copy the functions to row 12. In cell C12, insert a relative reference to the ending balance in cell G11. Select the range A11:B12, and then use the fill handle to complete the columns through row 70. (Note the cells to select here - it is just A11:B12 - not the whole range.)
Solved by O. J. in 24 mins
How to I use relative/abs/mixed cell reference if I want to drag down but I want to array to go one the right instead of down
Solved by V. U. in 27 mins