VLOOKUP Help

[Guest]

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.

 

[Guest]

Hi Rick,

try

Col A: Product Code
Col B = vlookup(a2,Sheet1!$a$1:$d$1501,2,0)
Col C = vlookup(a2,Sheet1!$a$1:$d$1501,3,0)
Col D = vlookup(a2,Sheet1!$a$1:$d$1501,4,0)

Does this help?
regards from Brazil
Marcelo





"Big Rick" escreveu:

 

[Guest]

Thank you Marcello. That did the trick. Regards from England.

Perhaps you or someone else could point me in the right direction to website
for VLOOKUP **beginers**.

 

[Guest]

Hi, Rick, thanks for the feedback,
here you are:

http://www.bettersolutions.com/excel.aspx

http://www.bettersolutions.com/excel/EDH113/QK747564521.htm

regards
Marcelo

"Big Rick" escreveu:

 

[Guest]

Thank you once again.

BTW, Sorry above the previous post. I got carried away with the enter key.

 

[Dave Peterson]

One more:
http://contextures.com/xlFunctions02.html
(Debra Dalgleish's site)