Excel, Formulas and Functions

Copper Contributor

how do I replace #REF! in a formula with a variable cell reference in Excel.  Using Win10, Microsoft Office Home and Student 2019

1 Reply



First of all, you should make sure you know WHY you're getting the #REF error, so that you're not just putting a bandaid on a problem that needs surgery.


Second, if you know the answer to that first question, it sounds like a job for the INDIRECT function. You can read up on that here.