i am new user. i use VLOOkUP to match same items from 1 wksht with th
other. "=VLOOKUP($H12,SLOW,2,FALSE)" if item of sht1 of cell H1
matches item in another sht with its range NAMED "SLOW" it should sho
the value under the colume "2", in this case is "1", if not it shoul
show "0", but when there is no match it show "#NA" instead.

plshelp me.

thank

--
yimc
-----------------------------------------------------------------------
yimcw's Profile: http://www.excelforum.com/member.php...fo&userid=1591
View this thread: http://www.excelforum.com/showthread.php?threadid=27394