| ·¢»õÆÚÏÞ: ×ÔÂò¼Ò¸¶¿îÖ®ÈÕÆð ÌìÄÚ·¢»õ | ËùÔÚµØ: ±±¾© |
| ÓÐЧÆÚÖÁ£º ³¤ÆÚÓÐЧ | Æ·ÅÆ£º±±¾©³çÎÄÃÅ»á¼ÆÖ¤ÅàѵѧУ |
ÏêÇé½éÉÜ


Êý×éÐÎʽ£ºLOOKUP£¨1ookup_va1ue£¬array£©ÓÃÓÚÔÚÊý×éµÄµÚÒ»ÐлòµÚÒ»ÁÐÖвéÕÒÖ¸¶¨µÄÖµ£¬²¢·µ»ØÊý×é×îºóÒ»Ðлò×îºóÒ»ÁÐÄÚͬһλÖõÄÖµ¡£Êý×éÊÇÖ¸ÓÃÓÚ½¨Á¢¿ÉÉú³É¶à¸ö½á¹û»ò¿É¶ÔÔÚÐкÍÁÐÖÐÅÅÁеÄÒ»×é²ÎÊý½øÐÐÔËËãµÄµ¥¸ö¹«Ê½¡£Êý×éÇøÓò¹²ÓÃÒ»¸ö¹«Ê½£»Êý×é³£Á¿ÊÇÓÃ×÷²ÎÊýµÄÒ»×é³£Á¿¡£



µã»÷½»Ì¸
µã»÷½»Ì¸
µã»÷½»Ì¸
µã»÷½»Ì¸
µã»÷½»Ì¸