Paste with Blank Rows?
 

I have the following setup in worksheet 1:
Item Qty
Apples 5
Oranges 2
Bananas 10

I want it to appear in worksheet 2 as:
Item Qty
Apples 5
Strawberries
Oranges 2
Cherries
Lemons
Blueberries
Bananas 10
Peaches
Pears

Is there a way that I can get the values from worksheet 1 to worksheet 2
without have to cut and paste each of the individual values?

Paste with Blank Rows?
 

Sounds like homework; check out -VLookUp-

trishlee;455763 Wrote:
I have the following setup in worksheet 1:
Item Qty
Apples 5
Oranges 2
Bananas 10

I want it to appear in worksheet 2 as:
Item Qty
Apples 5
Strawberries
Oranges 2
Cherries
Lemons
Blueberries
Bananas 10
Peaches
Pears

Is there a way that I can get the values from worksheet 1 to worksheet
2
without have to cut and paste each of the individual values?


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=126150

Paste with Blank Rows?
 

try =VLOOKUP(A1,Sheet1!$A$2:$B$11,2,FALSE)
where a1 = item, sheet1 and range of lookup ($, locks the cells), 2 = column
you are wanting results from and false is saying exact match
then copy the formula down

"trishlee" wrote:

I have the following setup in worksheet 1:
Item Qty
Apples 5
Oranges 2
Bananas 10

I want it to appear in worksheet 2 as:
Item Qty
Apples 5
Strawberries
Oranges 2
Cherries
Lemons
Blueberries
Bananas 10
Peaches
Pears

Is there a way that I can get the values from worksheet 1 to worksheet 2
without have to cut and paste each of the individual values?

Paste with Blank Rows?
 

And if you don't want to see all those #N/A errors use this formula to hide
them.

=IF(ISNA(VLOOKUP(A2,Sheet1!$A$2:$B$11,2,FALSE)),"" ,VLOOKUP(A2,Sheet1!$A$2:$B$11,2,FALSE))

Entered in Sheet2 at B2 and copied down.


Gord Dibben MS Excel MVP


On Mon, 17 Aug 2009 13:00:01 -0700, David
wrote:

try =VLOOKUP(A1,Sheet1!$A$2:$B$11,2,FALSE)
where a1 = item, sheet1 and range of lookup ($, locks the cells), 2 = column
you are wanting results from and false is saying exact match
then copy the formula down

"trishlee" wrote:

I have the following setup in worksheet 1:
Item Qty
Apples 5
Oranges 2
Bananas 10

I want it to appear in worksheet 2 as:
Item Qty
Apples 5
Strawberries
Oranges 2
Cherries
Lemons
Blueberries
Bananas 10
Peaches
Pears

Is there a way that I can get the values from worksheet 1 to worksheet 2
without have to cut and paste each of the individual values?