Copying formula by changing only one rule.
[Solved/Closed]
Report
shan_asa
shan_asa
- Posts
- 7
- Registration date
- Sunday October 29, 2017
- Status
- Member
- Last seen
- December 5, 2017
shan_asa
- Posts
- 7
- Registration date
- Sunday October 29, 2017
- Status
- Member
- Last seen
- December 5, 2017
Related:
- Copying formula by changing only one rule.
- Formula to change date format in excel to dd/mm/yyyy - How-To - Excel
- Excel formula to change font color with conditional formatting ✓ - Forum - Excel
- Copying formulas to multiple worksheets ✓ - Forum - Excel
- Copying % formula ✓ - Forum - Office Software
- Copying formula for multiple worksheets ✓ - Forum - Excel
1 reply
TrowaD
- Posts
- 2779
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- July 29, 2021
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
Subscribe To Our Newsletter!
DON'T MISS
- How to Fix a Blurry Snapchat Video
- Computer Boots to Black Screen
- How to Get More Followers on Instagram
- Facebook Code Not Received
- How to Install a VPN
- How to Get Free Diamonds in Free Fire
- How to Recover a Disabled Facebook Account
- How to Create a Gmail Account
- How to Upload High Quality Photos to Instagram
- How to Disabled Write Protection on a USB
- How to Recover Your Yahoo Account
You were of great help. Thank you very much.