Xlookup函數(shù)，我們?cè)娮R(shí)過(guò)它把Vlookup打進(jìn)冷宮的樣子。可有一個(gè)函數(shù)不服，它就是查找一哥 Lookup函數(shù)，今天蘭色帶大家看一場(chǎng)查找界的雙龍會(huì)，看一下到底是Lookup牛，還是Xlookup更厲害。

1、普通查找

Xlookup =XLOOKUP(A11,A2:A7,C2:C7)

Lookup  =LOOKUP(1,0/(A2:A7=A11),C2:C7)

簡(jiǎn)評(píng)：xlookup比lookup更簡(jiǎn)捷

2、反向查找

Xlookup =XLOOKUP(A11,B2:B7,A2:A7)

Lookup  =LOOKUP(1,0/(B2:B7=A11),A2:A7)

簡(jiǎn)評(píng)：同查找1，xlookup更簡(jiǎn)捷

Xlookup =XLOOKUP(A11&B11,A2:A7&B2:B7,D2:D7)

Lookup =LOOKUP(1,0/((A2:A7=A11)*(B2:B7=B11)),D2:D7)

Xlookup =XLOOKUP(A11,A2:A7,B2:B7,,-1)

Lookup =LOOKUP(A11,A2:B7)

Xlookup=XLOOKUP(A11,B2:B7,C2:C7,,,-1)

Lookup =LOOKUP(1,0/(B2:B7=A11),C2:C7)

Xlookup =XLOOKUP(A11,A2:A7,C2:C7,'')

Lookup =IFERROR(LOOKUP(1,0/(A2:A7=A11),C2:C7),'')

Xlookup=XLOOKUP(9^9,--RIGHT(A3,ROW(1:10)),--RIGHT(A3,ROW(1:10)),,-1)

Lookup =LOOKUP(9^9,--RIGHT(A3,ROW(1:10)))

Xlookup =XLOOKUP(9^9,FIND(A7,A$2:A4),B$2:B4,,-1)

Lookup =LOOKUP(9^9,FIND(A7,A$2:A4),B$2:B4)