Modification to an Existing Formula

[meppwc]

Can someone assist me with modifying the formula below.
=IFERROR(XLOOKUP(P18,'OBIEE TABLE'!B:B,'OBIEE TABLE'!G:G),"")
Instead of the double quotation marks near the end, I want to replace that existing logic with the following logic.
If the XLOOKUP fails, then leave the current value within the cell.
The current value in cell O18 "Color LaserJet CP2025n"

 

[Fluff]

Is that formula in O18?

 

[meppwc]

Yes, that is what makes it so complicated for me to figure out. It like the formula need to look at and remember the current value of that cell, BEFORE, taking action. I am just not sure if how to accomplish this.

 

[Fluff]

I am just not sure if how to accomplish this.

It can't. You would need VBA

 

[proficient]

=IFERROR(XLOOKUP(P18,'OBIEE TABLE'!B:B,'OBIEE TABLE'!G:G),O18)

 

[Fluff]

You cannot do that as it will create a circular reference & even if you enable iterative calculation, it still won't work as xl cannot "remember" what was in the cell.

 

[meppwc]

It can't. You would need VBA

It can't. You would need VBA

Thats what I was thinking as well. The only other option is to add an additional column so that I have a reference to map from when the xlookup fails. Guess it could not hurt to ask my question though.

 

[Fluff]

Glad to help & thanks for the feedback.