Linking Worksheets

[smallfella]

I have a worksheet which holds info about all of the products I am going to buy, something like this:

Col A-Code No
Col B-Product Description
Col C-Packaging

Is there any formula which would enable me to link this info into a separate worksheet?
I would like to be able to enter the relevant code number and for the rest of the information on the same row to copy over.
tia

[Bryan Hessey]

I have a worksheet which holds info about all of the products I am going to buy, something like this:

Col A-Code No
Col B-Product Description
Col C-Packaging

Is there any formula which would enable me to link this info into a separate worksheet?
I would like to be able to enter the relevant code number and for the rest of the information on the same row to copy over.
tia

If you are typing into column A (from A1) then in B1 put

=VLookup(A1,Sheet2!A:C,2,False)

and in C1 put

=VLookup(A1,Sheet2!A:C,3,False)

where A1 is where you are typing the code, and Sheet2 columns A, B and C hold your details.

hth
---

[smallfella]

Bryan,
That worked brilliantly thank you very much.

[Wedge120]

=VLookup(A1,Sheet2!A:C,2,False)

=VLookup(A1,Sheet2!A:C,3,False)


Help me break this down please:

Vlookup - calls for looking up a table
A1 - the value to be compared
Sheet2!A:C - the location of value to be compared to that of A1

I am unsure of the "2" and "false" as well as the "3" and "false". Help please.

[VBA Noob]

Hi,

The 2 and 3 is the column you want to return the value of column 1.

Say A1 = Jim and Jim was in A3 in sheet. If you use 2 it would return B3 value from Sheet 2 etc

The false is used for an exact match.

See attached for more info

http://office.microsoft.com/en-gb/ex...093351033.aspx

VBA Noob