Help needed to transfer data

catgirl

New Member
Joined
Nov 14, 2011
Messages
4
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,
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Jon von der Heyden

MrExcel MVP, Moderator
Joined
Apr 6, 2004
Messages
10,808
Office Version
  1. 365
Platform
  1. Windows
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

New Member
Joined
Oct 13, 2010
Messages
47
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

New Member
Joined
Nov 14, 2011
Messages
4
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
Joined
Apr 6, 2004
Messages
10,808
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

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

catgirl

New Member
Joined
Nov 14, 2011
Messages
4
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
Joined
Nov 14, 2011
Messages
4
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! :)
 

Watch MrExcel Video

Forum statistics

Threads
1,126,971
Messages
5,621,890
Members
415,864
Latest member
cybid

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top