Keeping a result in a IF function

[BryceN]

I have a lookup function nested in an IF function and my returns with my lookup is either the proper associated reference or "0.000". I used an If func. to say if (test)=0, "N/A", "". But i want the false statement to be what ever the reference is with the look up instead of blanks. How would I do this? is there a better function perhaps?

Where it's blank under reference is where I want the specific reference.

Thanks in advance.

 

[hagia_sofia]

I am not sure whether I understand it correctly, but e.g. XLOOKUP will return what you are looking for if true and has an optional argument to define what to return when false.

 

[dreid1011]

Nvm