# Help needed to transfer data

#### catgirl

##### New Member
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?

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

#### Jon von der Heyden

##### MrExcel MVP, Moderator
Hello

I believe VLOOKUP is what you are after.

So in spreadsheet 2 and in say B2:

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

##### New Member
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

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

##### New Member
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

##### MrExcel MVP, Moderator

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

#### catgirl

##### New Member
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

##### New Member
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!

Replies
7
Views
138
Replies
0
Views
31
Replies
12
Views
113
Replies
3
Views
102
Replies
3
Views
238

1,127,060
Messages
5,622,461
Members
415,895
Latest member
Akhilesh28

### 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.

### Which adblocker are you using?

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

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