Grab data from a column on sheet1 to sheet2 where theres a match of item#s

[webuxer]

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

[BadlySpelledBuoy]

Assuming your data starts in row 2 with row 1 as headers, put this in H2 and copy down.

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Change the 2 for relevant row number if your data does not start in row 2.

BSB

[shukla.ankur281190]

May be try

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Copy down!!!