ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] Ãö©óVLOOKUP ·j´M¤è¦¡

[µo°Ý] Ãö©óVLOOKUP ·j´M¤è¦¡

¤U¹Ï§Ú»Ý­n³z¹LVLOOKUP¨Ó·j´M§Ú»Ý­nªº¸ê®Æ
¥H¤U¹Ï¬°¨Ò°²³]§Ú·j´MªºªF¦è¬°1¡A­nÅý¥LÅã¥ÜÃþ§O¡A¨Ò¦p­nÅã¥Ü²Ä¤@Ãþ
¦ý¬OVLookup¦n¹³¥u¯àÅã¥Ü·j´M¸ê®Æªº¨ºµ§¸ê®Æ©¹«áªº¸ê®Æ
=VLOOKUP(B7,C1:H2,1,0)
«ç»ò­n¦p¦ó¤U¤½¦¡©O?

B6=HLOOKUP(B7,IF({1;0},C2:H2,C1:H1),2,)
OR
B6{=INDEX(C1:H1,MATCH(B7,C2:H2,))

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD