KBD = Kentucky Bourbon Distillers (aka Willett) L’Burg = Lawrenceburg, KY, where early Van Winkle and Eagle Rare were bottled. LDI = Lawrenceburg Distillers Indiana, former Seagrams Distillery (now MGPI) LE = Limited Edition L’Ville = Louisville Lot B = Van Winkle Special Reserve 12 yr,...
使用Vlookup函數將全州名稱轉換為縮寫 沒有直接的方法可以讓您在Excel中完成此工作,但是,您可以首先列出所有狀態名稱及其相對縮寫,然後應用Vlookup函數獲取任何縮寫。 首先,請複制左側狀態名稱及其縮寫並將其粘貼到您要使用的工作表中。 假設我將它們粘貼到單元格A1:B51中,並將數據范圍粘貼到D1:E11中,請參見屏幕截圖...