I have a "Products Database" formatted in an Excel Worksheet. The size is 27 columns by approx 2200 rows. In another section of the worksheet I have a single column with Product ID numbers. I would like to write a macro that will go through the single column list and compare each Product ID number with the Product IDs in my data base. When a match occurs, I want to change a value in the Products Database in the same row (different column) as the found ProductID.

I am fairly new to Excel, but am a retired Programmer with over 20 years of experience and am just looking for a little guidance. Is there a worksheet function that will do a Vertical Lookup and return the row number when a value matches?

Thanks,
Klaus Cook
Houston, Texas