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

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

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

        ÀR«ä¦Û¦b : °µ¸Ó°µªº¨Æ¬O´¼¼z¡A°µ¤£¸Ó°µªº¨Æ¬O·Mè¡C
ªð¦^¦Cªí ¤W¤@¥DÃD