Comments on: 9 Ways to Use Google Sheets Find and Replace (All Easy) https://spreadsheetpoint.com/find-and-replace-google-sheets/ Google Sheets Tips & Tutorials Thu, 16 Feb 2023 23:45:53 +0000 hourly 1 https://wordpress.org/?v=6.7.1 By: Paul https://spreadsheetpoint.com/find-and-replace-google-sheets/#comment-9741 Wed, 15 Jun 2022 17:18:52 +0000 https://spreadsheetpoint.com/?p=2873#comment-9741 How can I replace cell reference in a formula?
For example-my formula is “=INDEX(Cases!$F$5:$F$54,MATCH($B4,Cases!$C$5:$C$54,0))”. If I have 1000 cells using the same formula with same row range and now, I need to change the row range from 5:54 to 5:94 for all 1000 cells, how can I do that using Replace, in Google Sheet?

]]>