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!