How to retrieve informatoin from one file into another

[GuyMor]

Hello,

I'd like assistance with the following:
I have one google/excel sheet with a long list of products and various attributes to those products. For example Sheet 1 looks like:

Type	Colour	Serial number	Weight
A	A	A	A
B	B	B	B

And another google/excel sheet with more information but the only shared information is the serial number. Second sheet looks like this:

Serial Number	Cost	Quantity
A	A	A
C	C	C

I'd like to "pull" the cost of every matching serial number from sheet 2 into a new column in sheet 1, how do I go about doing that?

And just to clarify - and result will be adding a column to sheet 1 with the header "cost" (for example) and pull that value from sheet 2 by matching the serial number column

Thank you!

[Richard Buttrey]

Have you considered a VLOOKUP?

i.e. in sheet1 lookup C1 in sheet 2s A:B range and use number 2 (i.e. the 2nd columns) as the third element of the VLOOKUP

[GuyMor]

Great! does this work in google sheets as well?

[Richard Buttrey]

Great! does this work in google sheets as well?

I see no reason why not. Have you tried it?