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

«ç»ò¨Ï¥Î¨Ï¥ÎVLOOKUP¨Ï对应ªº资®Æ¦Û动¶ñ¤J

«ç»ò¨Ï¥Î¨Ï¥ÎVLOOKUP¨Ï对应ªº资®Æ¦Û动¶ñ¤J

¥»©«³Ì«á¥Ñ tomtracy ©ó 2016-3-21 20:13 ½s¿è

¦ì«e进¤j®a¦n:
§Ú¤S¦³问题¤F! 请¤j®aÀ°¦£ ! ÁÂÁÂ

test.rar (123.03 KB)

¤T¤d¦~Ū¥v, ¤£¥~¥\¦W§Q¸S, ¤E¸U¨½®©¹D, ²×Âk¸Ö°s¥Ð¶é

C3 =VLOOKUP(A3,IF({1,0},'log1 (2)'!A:A,OFFSET('log1 (2)'!A:A,,MATCH(V$1,'log1 (2)'!$2:$2,)-1)),2,)

G3 =VLOOKUP(A3&"²Ö计",IF({1,0},'log1 (2)'!A:A,OFFSET('log1 (2)'!A:A,,MATCH(V$1,'log1 (2)'!$2:$2,)-1)),2,)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

«e¶i  ±z¦n
      ÁÂÁ±z  §Ú­èÂå°|¦^¨Ó ¬Ý¨ì±zªº¦^ÂÐ ¹ê¦b·P¿E   §Ú·|¦n¦n¹B¥Îªº
±ß¦w

ÁÂÁÂ
¤T¤d¦~Ū¥v, ¤£¥~¥\¦W§Q¸S, ¤E¸U¨½®©¹D, ²×Âk¸Ö°s¥Ð¶é

TOP

        ÀR«ä¦Û¦b : µoµÊ®ð¬Oµu¼ÈªºµoºÆ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD