This content has been marked as final. Show 2 replies
Question as follows:
There are 2 fields as follows and 3rd field which does a lookup which i named Und Price as the final output:
Und Sec Price, Lookup Price, Und Price
What i want to do is a lookup formula to provide me the price in Und Sec Price when no price or null value is available in the column in Lookup Price.
If data is available in Lookup Price, I want it to over-write the Und Sec Price.
The final output is shown in the Und Price, which would show the combination.
I was thinking of doing a case statement but how could I do that here?
Happy Veterans day to fellow Vets like myself.