I have the following data:
gift_id suffix gift_desc size
BX02 Chateauneuf - Semi Dry White 750 ml (12)
BX07 Cabernet Sauvignon (VDP) 750 ML (12)
BX08 Valrose (VDP) 750 ML (12)
CH02 NYS White Sparkling 187 ML (24)
CH02 NYS White Sparkling 750 ml (12)

I would like to return a value in the "suffix" column based on the text in
the "size" field.
for example =IF(ISNUMBER(SEARCH("750",D2)),-750). I want -750 to appear in
the suffix column if partial text "750" appears in the size column and
similarly I want 187 to appear in the suffix column if partial text "187"
appears in the size column. Similarly, there are other values I want to
appear based on values later in the spreadsheet. My real goal is to append
the gift_id with those values in the suffix column. Does any one have any
ideas?