hi, aladin,
thks for the tips, but sounds complicated to me, is there a simpler
method. i chek some of the old files which uses this same formula but
dun have such problem, but the guy who created this files had left long
ago.

i am still...


--
yimcw
------------------------------------------------------------------------
yimcw's Profile: http://www.excelforum.com/member.php...o&userid=15916
View this thread: http://www.excelforum.com/showthread...hreadid=273944

yimcw Wrote:
hi, aladin,
thks for the tips, but sounds complicated to me, is there a simple
method. i chek some of the old files which uses this same formula bu
dun have such problem, but the guy who created this files had left lon
ago.

i am still...

=IF(ISNA(VLOOKUP($H12,SLOW,2,0)),0,VLOOKUP($H12,SL OW,2,0))

0 has the same meaning/effect as FALSE

--
Aladin Akyure
-----------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...nfo&userid=416
View this thread: http://www.excelforum.com/showthread.php?threadid=27394