=VLOOKUP(A3,表2!$A$1:$B$28,
问题描述:
=VLOOKUP(A3,表2!$A$1:$B$28,
答
根据A3的值,到表2!$A$1:$B$28范围查找匹配的值,找到后取其后面1列(同行)中的值.
要求精确匹配
=VLOOKUP(A3,表2!$A$1:$B$28,2,0)