Help needed to transfer data

[catgirl]

Hello,

I stumbled across this forum and hope someone can help me, or tell me if it is possible?
I have spreadsheet 1 with product information, coloumn A is product number, coloumn B is product description,
I have spreadsheet 2 with product number in coloumn A and need to fill in coloumn B with the product descriptions from spreadsheet 1.

The issue I have is not all products are in spreadsheet 2, so I can't just sort by coloumn A and copy and paste.

Is there a way to do this quickly?
Many thanks for any advice,

 

[Jon von der Heyden]

Hello

I believe VLOOKUP is what you are after.

So in spreadsheet 2 and in say B2:

=VLOOKUP(A2,spreadsheet1!A:B,2,0)

Where:

A2 is the product id you are looking up
spreadsheet1A:B refers to the complete table
2 indicate that you want to draw the result from the 2nd column of the grid
0 indicates that you are looking for exact matches

 

[rksample]

All you need to do is us vLookup. Lets say if you have in spreadsheet 1:

A B
1 Balls
2 Balloons
3 Bikes
4 shoes

and in spreadsheet 2:

A B
2
4

you can use the following formula in cell B1 of spreadsheet 2 and copy paste the formula in B column for other products as well.

=VLOOKUP(A1, Sheet1!A:B, 2, FALSE)

If you don't want errors to be displayed for non-available products, then you use the following formula:

=IFERROR(VLOOKUP(A1, Sheet1!A:B, 2, FALSE), "")

 

[catgirl]

Thank you for your help and taking the time to reply so quickly, this formula has worked for me.
Can you advise how I can easily add this formula to the next row's, I have tried to drag but is does not change the formula to correspond with each row?

 

[Jon von der Heyden]

It should do. Can you post the formula exactly as you have it?

 

[catgirl]

I have the formula as:

=VLOOKUP(A1, Sheet1!A:B, 2, 0)

I moved the 1st speadsheet to sheet 1 to make it easier for me. The A10 doesnt change if I drag, even with the Ctrl key held down.

 

[catgirl]

Sorry, I'm being stupid, it has changed the cell, I had not dragged enough!

This works perfectly, thank you again, This is a great forum!