Hello,

I need help from the experts.
I currently have an excel spreadsheet, sheet1 contains approximately 20,000 records of products with column "A" having a unique number for every product (theres no repeats), from column B to W there's more data pertaining to the product like description, quantity onhand (Column "E") etc.... I also have another sheet, sheet2. This sheet lists about 5000 products starting on column "A" with its item number (no repeats) but on this list there's some items that are a match with items on sheet1. I need a formula that can move the quantity onhand from sheet1 Column "E" to sheet2 (column "H") where the item numbers match. Any help will be much appreciated.

Thank you