Anonymous
Anonymous asked in 電腦與網際網路軟體 · 1 decade ago

要如何使用VLOOKUP,才能區分大小寫???

假設Excel中

參照陣列

A欄[ A , a , B , b , C , c ]

B欄[31,32,33,34,35,36]

[C1]( b )....(目標文字)

要如何使用公式才能在 [D1] 顯示 (34) ???

我使用VLOOKUP,但無法區分大小寫???

Update:

我嘗試多次後的可行方法!!

A欄[符, A , a , B , b , C , c ,....]

B欄[號,31,32,33,34,35,36,....]

[C1]=CONCATENATE(A2,A3,A4,A5,A6,A7,A8,A9,....,A100)

[D2]=( b )....(目標文字)

答案

[E2]=INDEX($B$2:$B$100,FIND(D2,$C$1)))

2 Answers

Rating
Still have questions? Get your answers by asking now.