Thats
=IF(ISERROR(VLOOKUP(A9,$C$154:$G$680,2,FALSE)),"", VLOOKUP(A9,$C$154:$G$680,2,FALSE))
"comotoman" wrote
in message ...

=if(iserror(VLOOKUP(A9,$C$154:$G$680,2,FALSE),"
",VLOOKUP(A9,$C$154:$G$680,2,FALSE)))

i get an error message base on the " "


--
comotoman
------------------------------------------------------------------------
comotoman's Profile:
http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=468285