【记录】Excel 中VLOOPUP 使用心得

=IF(ISNA(VLOOKUP(F3,$B$3:$C$6,1,0)),"匹配不到",VLOOKUP(F3,$B$3:$C$6,1,0))

=VLOOKUP(F3,$B$3:$C$6,1,0)