Hi,
You can create a formula to check if the field in excel i.e. partnumbers match with partnumber in sql table if they don't match display message "Item Not Found" ,Place the formula in details section....
formula
IF EXCELPARTNUMBER <> SQLPARTNUMBER then
"Item not Found"
Cheers
Rahul
Edited by rahulwalawalkar - 26 Feb 2008 at 12:41am