[ ίΔΜϋΦ | κ(ΕVXV) | SΆυ | ίO ]
@
w²έΓή―Έ½ΦΜπΐΡΦ¦ιΖxiά’ρj
=INDEX($AZ$4:$BD$20,³Πυ!U40,VLOOKUP(³Πυ!AZ40,x¦!kae,2,0))
γLΜζ€ΘΦΜ ι\ΕΐΧΟ¦πΐs·ιΖ
ΐΧΦ¦½ΫΙAU40βAZ40ΰ»ΜsΙΐΧΟ¦ΔΩ΅’ΜΕ·ͺAΟνθάΉρB
indexΦΙβθͺ ιΜ©AΜμθϋΙβθ ιΜ©B
ΗΘ½©²ΆmΕ΅½η²³φθ’ά·B
ΏΘέΙAGNZQOOR
WINXPΙΘθά·B
>γLΜζ€ΘΦΜ ι\ΕΐΧΟ¦πΐs·ιΖΐΧΦ¦½ΫΙA >U40βAZ40ΰ»ΜsΙΐΧΟ¦ΔΩ΅’ΜΕ·ͺAΟνθάΉρB
(1)½πξΙΐΧΦ¦ιΖA (2)»Μsͺ(α¦Ξ)½ΙΘθA (3)»κΙΊΑΔAU40βAZ40ͺΗ€ΘΑΔ~΅’ΜΕ·©H
(4)³Πυ!U40Ζ©AVLOOKUP(³Πυ!AZ40,x¦!kae,2,0) Ζ©ΝA @ΗρΘlΙΘΑΔ’ιΜΕ·©H
@o½ηATvf[^ΰf¦΅ΔΎ³’B
(Ό½Ύ) 2010/11/29 20:18
[ κ(ΕVXV) ]
YukiWiki 1.6.7 Copyright (C) 2000,2001 by Hiroshi Yuki.
Modified by kazu.