Copying formula by changing only one rule.
Solved/Closed
shan_asa
Posts
7
Registration date
Sunday October 29, 2017
Status
Member
Last seen
December 5, 2017
-
Nov 7, 2017 at 10:37 AM
shan_asa Posts 7 Registration date Sunday October 29, 2017 Status Member Last seen December 5, 2017 - Nov 7, 2017 at 01:03 PM
shan_asa Posts 7 Registration date Sunday October 29, 2017 Status Member Last seen December 5, 2017 - Nov 7, 2017 at 01:03 PM
Related:
- Copying formula by changing only one rule.
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Credit summation formula - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Nov 7, 2017 at 11:59 AM
Nov 7, 2017 at 11:59 AM
Hi Shan_asa,
What you are looking for is changing relative cell references to absolute cell refrences. This is done by placing a dollar symbol in front of either the column letter or the row number or both.
You can do this manually or selecting the range in the formula and hit F4. Hitting it multiple times cycles through the different options (row, column or both and then back to none)
When you apply this knowledge to your formula it will look like this:
=INDEX((Sheet1!B$2:B$99),MATCH(B24,Sheet1!A$2:A$99,0))
Since you are dragging your formula down, there is no need to place dollar signs in front of the column letter.
Best regards,
Trowa
What you are looking for is changing relative cell references to absolute cell refrences. This is done by placing a dollar symbol in front of either the column letter or the row number or both.
You can do this manually or selecting the range in the formula and hit F4. Hitting it multiple times cycles through the different options (row, column or both and then back to none)
When you apply this knowledge to your formula it will look like this:
=INDEX((Sheet1!B$2:B$99),MATCH(B24,Sheet1!A$2:A$99,0))
Since you are dragging your formula down, there is no need to place dollar signs in front of the column letter.
Best regards,
Trowa
Nov 7, 2017 at 01:03 PM
You were of great help. Thank you very much.