VLOOKUP??

[nicoleHSI]

I'm extremely new to this, and would really love some help.
Hopefully someone out there is able to explain this in a way I can understand.

I have a workbook with multiple pages that are all related in some way.

Page 2 of the workbook has a list of serial numbers, item codes, and descriptions- simplified example:
12345 MN123 Bottle
12234 MN234 Chair
12334 MN 345 Fork

On page 3 of the workbook, I have an log where I want to reduce double data entry.
Column A has the serial # 12345 to be chosen from a list. I want column B and C to fill in automatically based on the choice from column A, using the matched data in page 2.

When I attempt to use a Vlookup function I am unable to specify the correct array.
Am I approaching this completely wrong?
Would anyone be willing to explain the process of how this works?

Thank you!

 

[NBVC]

I think Vlookup() is the correct approach.

It should look something like this:

=Vlookup(A2,Sheet2!$A$2:$C$100,2,0) for item codes

and


=Vlookup(A2,Sheet2!$A$2:$C$100,3,0) for descriptions

where A2 is your serial number to look up.
Sheet2 is the name of your "page 2" sheet
A2:C100 is the table range

adjust ranges and sheet names as necessary