$B%(%/%;%k(B $B%j%9%H(B0$B#4(B
$B%(%/%;%k$NM}2r%7%j!<%:(B
$B$=$N#4(B
How to find data in an Excel table
$BFCDj$N%;%kHO0O$G%G!<%?$r8!:w$9$kJ}K!$N$^$H$a(B

 

A

B

C

D

E

1

$BL>A0(B

$BIt=p(B

$BG/Np(B

 

$B8!:w$9$kCM(B

2

$B;30*(B

$B1D6H(B

28

 

$B6LG,(B

3

$B@8U*(B

$BAmL3(B

19

 

 

4

$B6LG,(B

$B7PM}(B

22

 

 

5

$B>.>>:Z(B

$B3+H/(B

29

 

 

 

 

$B4X?t$N9=J8!J=q<0!K(B

$B8!(B
$B:w(B

=LOOKUP(E2,A2:A5,C2:C5)

=LOOKUP(   E2  , A2:A5  ,  C2:C5 )
                 $B",(B       $B",(B          $B",(B
=LOOKUP($B8!::CM(B,$B8!::HO0O(B,$BBP1~HO0O(B)

$B=D(B
$B8!(B
$B:w(B

=VLOOKUP(E2,A2:C5,3,FALSE)

=VLOOKUP(   E2  ,A2:C5,   3   ,  FALSE )
                   $B",(B      $B",(B     $B",(B        $B",(B
=VLOOKUP($B8!:wCM(B,$BHO0O(B,$BNsHV9f(B,$B8!:w$N7?(B)

$B8!(B
$B::(B

=INDEX(A2:C5,MATCH(E2,A2:A5,0),3)

=INDEX(A2:C5,      MATCH(   E2  , A2:A5  ,    0      ),   3   )
             $B",(B                       $B",(B       $B",(B         $B",(B         $B",(B
=INDEX($BG[Ns(B,$B9THV9f(BMATCH($B8!::CM(B,$B8!::HO0O(B,$B>H9g$N7?(B),$BNsHV9f(B)

$B$:(B
$B$i(B
$B$7(B
$B8!(B
$B::(B

=OFFSET(A1,MATCH(E2,A2:A5,0),2)

=OFFSET(  A1 ,     MATCH(   E2  ,  A2:A5  ,     0     ),   2  )
                $B",(B                     $B",(B       $B",(B          $B",(B        $B",(B
=OFFSET($B4p=`(B,$B9T?t(BMATCH($B8!::CM(B,$B8!::HO0O(B,$B>H9g$N7?(B),$BNs?t(B,$B9b$5(B,$BI}(B)

$B"((B
$B$4(B
$BCm(B
$B0U(B

LOOKUP$B4X?t(B
$B>e5-$N%5%s%W%k%G!<%?$K4p$E$$$FF~NO$7$^$9$H!"(B$B!t#N(B/A($B!a(BNot Available, $B$B$N%(%i!<(B$B$K$J$C$F$7$^$$$^$9!#(B
$B$J$<$=$&$J$k$+$H$$$$$^$9$H!"(B
LOOKUP($B%k%C%/%"%C%W(B)$B4X?t!"$*$h$S(B
VLOOKUP($B%t%$%k%C%/%"%C%W(B)$B4X?t$H(BHLOOKUP($B%(%$%A%k%C%/%"%C%W(B)$B4X?t(B
$B$G(B$B8!:w$N7?(B$B$r!V(BTRUE$B!W$NIT40A40lCW$K$7$?>l9g!"(B
$B8!:w$r:=g$K$7$?>e$G8!:w$7$F$$$/$h$&$K(B$B!JJ8;z%3!<%IHV9f$N>.$5$$=g$+$i!"$=$N0l$D0l$D$,0lCW$9$k$+H]$+$r8!:w$9$k!K(B$B@_7W$5$l$F$$$^$9(B$B!JBgA0Ds!K$N$G!"(B
$B$3$l$i$N4X?t$r$4;HMQ$K$J$k$H$-$K$O!"(B$B8!::HO0O$NJ8;zNs$r>:=g$GJB$YBX$($r$7$?8e$G!"4X?t$N=q<0!J9=J8!K$rF~NO(B$B$7$F$/$@$5$$!#(B
$B%X%k%W$G$O!"$3$N$3$H$r!V(B$B8!::CM(B$B$,(B$B8!::HO0O(B$B$K4^$^$l$k:G>.CM$h$j$b>.$5$$$H!"!t#N(B/A$B$N%(%i!


$B#H#O#M#E$XLa$k(B                   $B$=$N#3$X(B                 $B$=$N#5$X(B