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

¦p¦ó¦Û°Ê±a¤J2

¥»©«³Ì«á¥Ñ vvcvc ©ó 2011-6-15 22:55 ½s¿è

¤£ª¾³o¬O¤£¬O§A­nªºµ²ªG
E1=INDEX(A:C,MATCH($F$1,B:B,0),1)
G1=INDEX(A:C,MATCH($F$1,B:B,0),3)

TOP

¥[­Óif
=IF(F1="","",INDEX(A:C,MATCH($F$1,B:B,0),1)

TOP

        ÀR«ä¦Û¦b : ¤H­nª¾ºÖ¡B±¤ºÖ¡B¦A³yºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD