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

[µo°Ý] Ãö©ó vlookup...¥X #REF!

[µo°Ý] Ãö©ó vlookup...¥X #REF!

¸Õ¤F«Ü¦h¦¸³£¸Ñ¨M¤£¤F
¥Øªº·Q¦b data In ¿é¤J item no....Qty....
¦Û°Ê¤ÀÃþ¸õ¨ì "¤u§@ªí1"  Qty

¦ý¥Î vlookup ¬O¥i¥H¸õ¨ì, ¦ý¥uÅã¥Ü #REF!

¥i¯à»¡±o¤£²M·¡
½Ð¬Ýªþ¥ó ¬¡­¶Ã¯2.rar (8.65 KB)

thanks

¦^´_ 1# kkttin

¤½¦¡­×§ï¦p¤U¡A¸Õ¸Õ¬O§_²Å¦X»Ý¨D¡H
B4=VLOOKUP(A4,'Data in'!A:B,2,FALSE)  ¦V¤U½Æ»s

TOP

B2 =IF(COUNTIF('Data in'!A:A,A2),VLOOKUP(A2,'Data in'!A:B,2,),"")
¤U©Ô½Æ»s¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

THanks All
­ì¨Ó´N¬O³o¸Ì¥X°ÝÃD

TOP

½Ð°Ý¬O­þ¸Ì¦³°ÝÃD?

TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD