How to lock in specific cells in a formula going down rows
Solved/Closed
Related:
- How to lock in a row in excel
- How to lock a row in excel formula - Best answers
- How to fix cells in excel formula - Best answers
- How to delete a row in word - Guide
- How to change date format in excel - Guide
- Saints row 2 cheats - Guide
- How to clear formatting in excel - Guide
- Arrow keys not working in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
Jun 27, 2022 at 12:01 PM
Jun 27, 2022 at 12:01 PM
Hi JoshL,
What you are looking for is the dollar symbol.
When you place it in front of a column letter, dragging that cell horizontally won't change the column letter.
Placing it in front of a row number, dragging that cell vertically won't change the row number.
You can also place it in front of both column letter and row number to lock the cell reference completely.
When placing your cursor in the middle of a cell reference (or multiple / all) of your formula, hitting F4 will cycle through all the variations.
In short, your formula would look like this:
=IF(AP2=Sheet2!K$3,Sheet2!L$3,IF(AP2=Sheet2!K$4,Sheet2!L$4,IF(AP2=Sheet2!K$5,Sheet2!L$5,IF(AP2=Sheet2!K$6,Sheet2!L$6,IF(AP2=Sheet2!K$7,Sheet2!L$7,IF(AP2=Sheet2!K$8,Sheet2!L$8,IF(AP2=Sheet2!K$9,Sheet2!L$9,)))))))
Best regards,
Trowa
What you are looking for is the dollar symbol.
When you place it in front of a column letter, dragging that cell horizontally won't change the column letter.
Placing it in front of a row number, dragging that cell vertically won't change the row number.
You can also place it in front of both column letter and row number to lock the cell reference completely.
When placing your cursor in the middle of a cell reference (or multiple / all) of your formula, hitting F4 will cycle through all the variations.
In short, your formula would look like this:
=IF(AP2=Sheet2!K$3,Sheet2!L$3,IF(AP2=Sheet2!K$4,Sheet2!L$4,IF(AP2=Sheet2!K$5,Sheet2!L$5,IF(AP2=Sheet2!K$6,Sheet2!L$6,IF(AP2=Sheet2!K$7,Sheet2!L$7,IF(AP2=Sheet2!K$8,Sheet2!L$8,IF(AP2=Sheet2!K$9,Sheet2!L$9,)))))))
Best regards,
Trowa
Jun 27, 2022 at 09:42 PM
Thank you so much! That worked perfectly, really appreciate your help. Have a good day.
Kind regards,
Josh