In colum A of sheet1 are the part number. Sheet2 is use to download latest datas. The same part numbers and new part numbers will be downloaded in sheet2. I need to set the left colum of the part numbers in sheet2 to check against the part numbers in sheet one. Then indicate in this colum "1" if there is a match and indicate "NEW" when there is no match against each part number. What function do I use to to perform this task.
Thanks for any help. :guitar: :thanx: :thanx:
Aways wanted to learn more.