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

@BrianMH 

 

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.