MrExcel.com Online Store : Excel Guru : =IF(ISNA(),VLOOKUP) White T-Shirt
=IF(ISNA(Match($A2,$X$1:$X$500,False)),"Zone "&A2,VLookup($A2,$X$1:$Z$500,3,False))