# vlookup，如何匹配文本类型数字与数值类型数字

=VLOOKUP(What you want to look up,
where you want to look for it,
the column number in the range containing the value to return,
return an Approximate or Exact match – indicated as 1/TRUE, or 0/ALFSE).

（1）用文本类型数字匹配数值类型数字

=VLOOKUP(B2*1,exp3_scores.csv!$B$1:$D$65536,3,FALSE)

（2）用数值类型数字匹配文本类型数字

=VLOOKUP(B2&"",[exp3_scores_reports.xls]Sheet1!$B:$E,4,FALSE)