VLOOKUP??

nicoleHSI

New Member
Joined
Jun 28, 2006
Messages
19
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!
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
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
 

Watch MrExcel Video

Forum statistics

Threads
1,133,654
Messages
5,660,140
Members
418,553
Latest member
judithcatherine

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top