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