excel-day08

vlookup函数

 

=VLOOKUP(G6,$B$5:$E$10,4,0)

 

数据源

 

 

 =VLOOKUP(A2,数据源!A:B,2,0)

 

=VLOOKUP(A2&"*",数据源!B:E,4,0)

 

=VLOOKUP(G9,$C$8:$D$13,2,1)

 

=VLOOKUP(F4&"",$A$1:$C$6,3,0)

=VLOOKUP(F12*1,$A$9:$C$14,3,0)

 =IF(ISNA(VLOOKUP(F20*1,$A$18:$C$22,3,0)),VLOOKUP(F20&"",$A$18:$C$22,3,0),VLOOKUP(F20*1,$A$18:$C$22,3,0))

 

=HLOOKUP(B14,$1:$3,3,0)

 

=VLOOKUP(F7,$A$5:$D$12,3,1)*F7