Modify and add extra condition
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.
|