Hi,

The following formula establishes if there is a match for B158

=IF(ISNA(MATCH(B158,'formula Test'!$A:$A,0)),IF(ISNA(MATCH(B158,'formula
Test'!A:A,0)),"No Match Found",B158),B158)

I now want to modify and add an extra condition.

When a match is found in 'formula Test'!$A:$A I want to establish if the
corresponding cell in column D contains a value and return that value
instead.

For example:

B158 = €œApples€�

€œApples€� has been match to A364 in 'formula Test'!$A:$A

The cell in D364 'formula Test'! = €œRed Apples€�

The formula should return €œRed Apples€�

If cell D364 had not contained a value then nothing should be returned.