Help with moving info from one spreadsheet to another

[Michael R Murphy]

Hello, I need some help to same me some time. I have #1 spreadsheet that has 75 model numbers and no pricing. I have #2 spreadsheet that has 675 model numbers and pricing on it. How can I copy only the pricing from 2 to 1 with out a lot of work.

 

[SQUIDD]

Hi Michael

Im not sure if i ma missing something?
Can you not simple copy and paste the price?
Or, are the prices and model number within the same cells in 1 column?

If they are in the same cells, perhaps give us an example of what the data looks like within the cells.

Cheers

Dave

 

[Michael R Murphy]

Squidd, using a copy and past would take hours. In sheet one I have about 657 model numbers with prices. In Sheet 2 I have about 213 models (same models as in Sheet 1). I want to copy the pricing over to Sheet 2 in one move or with one formula. Thank you for your assistance.

Sheet 1. Model Price Sheet 2. Model Price
1x 10.00 1x ?

 

[SQUIDD]

Hi Michael

did you find a solution to this problem yet?

Dave

 

[Michael R Murphy]

Yes I did Dave, I tried a VLOOKUP and it worked. Had to practice a while to get it but got it now. Thank you.