How to lock in specific cells in a formula going down rows
Solved/Closed
Related:
- How to lock in specific cells in a formula going down rows
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- How to find specific words on a page - Guide
- Tentacle lock - Download - Adult games
- How to lock samsung screen from touch - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
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