VLOOKUP Help
Hello Folks
Try as I might, I cannot get my head around VLOOKUP.
I would be very grateful if somebody could help me out.
What I want to do is have a list of 1500 products.
On "Products List" sheet.
Col A = Product Code
Col B = Product Description
Col C = Case Quantities
Col D = Price
On a seperate sheet (called Outlet1), I want to enter the product code and
have the description, quantities, and price automatically alter on the next 3
columns.
Your help is and always has been very much appreciated.
Thanking you in anticipation.
--
Big Rick
|