Thread: stuck with VLOOKUP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
yimcw yimcw is offline
external usenet poster
  
Posts: 1
Default stuck with VLOOKUP

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

Reply With QuoteReply With Quote