[[20081006163116]]@w’Šo‚Ι‚Β‚’‚āxiƒPƒ“j@ƒy[ƒW‚ΜΕŒγ‚Ι”ς‚Τ

[ ‰‚ί‚Δ‚Μ•ϋ‚Φ | ˆκ——(ΕVXV‡) | ‘S•ΆŒŸυ | ‰ί‹ŽƒƒO ]

@

w’Šo‚Ι‚Β‚’‚āxiƒPƒ“j

    A         B            @   C         D
1   91  •½¬‚Q‚T”N‚PŒŽ‚P“ϊ   @410  •½¬‚Q‚O”N‚P‚OŒŽ‚P“ϊ
2   92  •½¬‚Q‚T”N‚QŒŽ‚P“ϊ
3   93  •½¬‚Q‚T”N‚RŒŽ‚P“ϊ
4  410  •½¬‚Q‚O”N‚P‚OŒŽ‚P“ϊ
5  411  •½¬‚Q‚O”N‚P‚PŒŽ‚P“ϊ

 γ‹L‚Μ‚ζ‚€‚Ι‚`—ρ‚Ι‚Ν˜A‘±‚΅‚Δ‚’‚Θ‚’‚ͺ”Žš‚ͺ“ό‚Α‚Δ‚¨‚θA‚»‚Μ‚Ζ‚Θ‚θ‚Μ‚a—ρ‚Ι‚Ν
“ϊ•t‚ͺ“ό‚Α‚Δ‚’‚ά‚·B
 ‚±‚Μ‚Ζ‚«‚ɁA‚b‚PƒZƒ‹‚Ι‚S‚P‚O‚Ζ“ό—Ν‚³‚κ‚½Žž‚ɁA‚c‚PƒZƒ‹‚Ι‚a‚S‚Μ•½¬‚Q‚O”N‚P‚OŒŽ‚P“ϊ‚π•\Ž¦‚³‚Ή‚½‚’‚Μ‚Ε‚·‚ͺA‚Η‚€‚·‚κ‚Ξ‚’‚’‚Ε‚΅‚ε‚€‚©H
 vlookup‚Ε‚Ν‚`—ρ‚̐”Žš‚ͺ˜A‘±‚΅‚Δ‚’‚Θ‚’‚½‚߁A‚€‚ά‚­’Šo‚Ε‚«‚ά‚Ή‚ρB
 ‘Ό‚Ι’Šo•ϋ–@‚ͺ‚ ‚κ‚Ξ‹³‚¦‚Δ‚­‚Ύ‚³‚’B
 ‚ζ‚λ‚΅‚­‚¨Šθ‚’‚΅‚ά‚·B
@


 >‚`—ρ‚̐”Žš‚ͺ˜A‘±‚΅‚Δ‚’‚Θ‚’‚½‚߁A‚€‚ά‚­’Šo‚Ε‚«‚ά‚Ή‚ρB
 ‚’‚ά‚’‚ΏˆΣ–‘‚ͺHHH
 =VLOOKUP(C1,A1:B14,2,FALSE)
 ‚Ε‚€‚ά‚­’Šo‚Ε‚«‚ά‚΅‚½‚ͺH


 ͺ‚Ν‚Η‚Θ‚½‚Ε‚΅‚ε‚€‚©BHN‚Μ‚²‹L“ό‚π‚¨–Y‚κ‚Θ‚­‚¨Šθ‚’‚΅‚ά‚·B

 ŽQlFVLOOKUPŠΦ”
http://www.excel.studio-kazu.jp/lib/e1tw/e1tw.html

 iμ–μˆΌ‘Ύ˜Yj

‚ ‚θ‚ͺ‚Ζ‚€‚²‚΄‚’‚ά‚΅‚½B
‚u‚Œ‚‚‚‹‚•‚ŠΦ”‚ΜΕŒγ‚ΙFALSE‚π“ό‚κ‚κ‚Ξ—Η‚©‚Α‚½‚ρ‚Ε‚·‚ˁOOG
’m‚θ‚ά‚Ή‚ρ‚Ε‚΅‚½B
•‚©‚θ‚ά‚΅‚½B

ƒRƒƒ“ƒg•ΤMF

[ ˆκ——(ΕVXV‡) ]


YukiWiki 1.6.7 Copyright (C) 2000,2001 by Hiroshi Yuki. Modified by kazu.