Function for replacing data within a cell if another cell has a value

[NickPDC]

Hi guys,

Needing some assistance with a formula I am trying to get working (If possible).

I basically have 2 formulas, looking up values from 2 different arrays.

One of these formulas does not always come up with a value, because there isn't always an attached value to what it is looking up, the other formula will always resolve a value as there is always something attached to the value it is looking up.

What I am trying to do is...

IF the formula that does not always come up with a value, comes up with a value. The text in the cell that always shows a value is replaced with that number.

Is this a simple task?

No.1.jpg

No.2.jpg

Thanks!

Nick