Match or Lookup should be all you need.

What do you need to add to that?

--
Regards,
Tom Ogilvy

"wally0206" wrote in message
...

all the info is in A:A , and the new scanned data is in B:B, and for now
the only code i have is lookup, I don't have any idea were to go from
there


--
wally0206
------------------------------------------------------------------------
wally0206's Profile:
http://www.excelforum.com/member.php...o&userid=14995
View this thread: http://www.excelforum.com/showthread...hreadid=269715