I have 2 columns in sheet2 performing almost the same function
Column F =IF(D6="","",IF(ISNA(MATCH(D6&"_"&E6,Sheet3!$K$4:$K$500,0)),"","New"))
Column G =IF(D6="","",IF(ISNA(MATCH(D6&"_"&E6,Sheet3!$E$4:$E$500,0)),"","SST"))
Both are using a helper column in Sheet3, Column E and K.
I would like to simplify into
1) Without using a helper column
2) Combine column F and G into one column to display either New, SST or " ".
Please help and give some advice.
Column F =IF(D6="","",IF(ISNA(MATCH(D6&"_"&E6,Sheet3!$K$4:$K$500,0)),"","New"))
Column G =IF(D6="","",IF(ISNA(MATCH(D6&"_"&E6,Sheet3!$E$4:$E$500,0)),"","SST"))
Both are using a helper column in Sheet3, Column E and K.
I would like to simplify into
1) Without using a helper column
2) Combine column F and G into one column to display either New, SST or " ".
Please help and give some advice.
Attachments

116.8 KB Views: 6