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
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- If cell contains specific text then return value in another cell ✓ - Excel Forum
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- Logitech formula vibration feedback wheel driver - Download - Drivers
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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