2010excel如何通过国家识别洲际

Question

如题所述

Answer 1

可以参考这个公式：=IF(COUNT(FIND({"北京","天津","河北","山西","内蒙古"},C33)),"华北",IF(COUNT(FIND({"辽宁","吉林","黑龙江"},C33)),"东北",IF(COUNT(FIND({"上海","江苏","浙江","安徽","福建","江西","山东"},C33)),"华东",IF(COUNT(FIND("河南",C33)),"华中",IF(COUNT(FIND({"湖北","湖南","广东","广西","海南"},C33)),"华南",IF(COUNT(FIND({"重庆","四川","贵州","云南","西藏"},C33)),"西南","西北"))))))

Answer 2

首先需要有一个明细表（SHEET2），两列，A列为“国家”， B列为“洲际”，然后就可能在SHEET1是的A1输入国家，在B1用公式得到洲际，公式：
=VLOOKUP(A1,Sheet2!A:B,2,)