Excel - TechRepublic
General discussion
June 1, 2011 at 01:03 AM
abdulnaserkm

Excel

by abdulnaserkm . Updated 15 years, 1 month ago

I have a Excel book with Two sheets
Sheet1 – List of Items with ID No. and Qty Column
Sheet2 – List of some selected items from sheet1 without Qty
My goal is to search sheet2 items in sheet1 and get the Qty to Sheet2 in the same raw of the item.
would you please help me how to create the formula

Thank you very much

This discussion is locked

All Comments