I have a formula I need written to solve the below problem. It needs to be a formula not a macro.
Please view attached images as a reference. I will attached a worksheet to work on.
I gave a hlook up formula in Column D. Its looking for a match in a specific cell of Column A. At times I want to delete rows in Column A, however I do not want to cell reference in the Hlook up formula to change.
I have $$ signs infront of all cell references, howeve the cells references in the formula still self adjust if I delete a row in column A.
Let me know if you can help!
60 freelancers estão ofertando em média $22 nesse trabalho
Hi, I can hep you to rewrite a formula using Match function. You will get correct results if you want to remove rows in column A. Would be great to hear from you, Best regards, Duong