Vlookup formula to return multiple cells (x) times.

[Choppo]

Hi All,
My second question and I'm hoping (praying) this isn't a hard one. Not sure if I'm in the right thread. I need to add 4 cells from sheet2 to sheet1 and I'm assuming vlookup will be used, but hold on. The info from sheet2 that I'm looking up is generated from a pivot table. Column "A", from the Pivot table, will list a part#(the lookup) and column B - E (the 4 cells I need returned) will list the address ( street, zip, city and St) and column F will list the quantity of how many times I'll need the each address pasted. So, because I'm using a pivot table, I could have 1 part# listed once and have 20 different addresses and each address would need to be pasted x times. You'll see in the attachment that sheet2 is where I've pasted the Pivot Table. The Lookup value is column K on sheet1 "concatenate" and B-E on sheet2 is what I want pasted in columns AB-AE. Column F, from sheet2 list how many times I need that particular address pasted. Thank you in advance!

[dilipandey]

Hi Choppo,

Why A5:A10 of sheet 2 is blank?
Can we fill this with values present in above cells ?

Regards,
DILIPandey
<click on below * if this helps>

[Choppo]

Thank you for your help and yes they can be populated with the above info. Again, that info is pasted from a pivot table. I would just need to copy/paste down. Thanks again

[dilipandey]

OKay.. sheet 1 column K's entries are not found in sheet 2 column A's entries.. can you show matching data along with your expected results ? thanks.



Regards,
DILIPandey
<click on below * if this helps>

[Choppo]

My error. I'm not sure why the data wasn't matching. I've added column "A" data from sheet2 to column "K" data on sheet1. It should work now. Providing a little more detail. Sheet1 data gets updated monthly with new address until complete, so next month's addresses will be used to populate the lines that weren't populated this month. Not sure if that matters, but i figured I can filter for the blank data I'll be working with and use the formula for it. Thank you much.

[dilipandey]

do you need the bottom(latest) address to be pasted from sheet 2 to sheet 1?

Check the attachment where I have manually pasted the data.. is this you want using formulas ? if not, then paste your expected results there. thanks.


Regards,
DILIPandey
<click on below * if this helps>

[Choppo]

I didn't see an attachment from you, so I've updated the spreadsheet to show the results I'd like to have. I've updated sheet2's column"A" and I've manually added the addresses to sheet1. The number to the right of the listed State represents the number of times that address gets pasted. If it's a 6, that address is listed 6 times, a 1 gets listed once and so-on and I would like the "qty" brought over as well.
I can not thank you enough for your time and your help.

[dilipandey]

Okay.. in sheet 1 why below data is repeated four times:-

201 NW 4TH ST 47708 EVANSVILLE IN 4
201 NW 4TH ST 47708 EVANSVILLE IN 4
201 NW 4TH ST 47708 EVANSVILLE IN 4
201 NW 4TH ST 47708 EVANSVILLE IN 4

Is it because it has 4 as the last result on right side ?
and if that is true then why not below data repeated for three time in sheet 1?

1 EATON CTR 44114 Cleveland OH 3

?



Regards,
DILIPandey
<click on below * if this helps>

[Choppo]

The number in the qty field is how many times I need the address pasted. "1 Eaton CTR 44114 Cleveland Oh" should have been pasted 3 times, but for whatever reason I just didn't do it. Thanks again for your help. it is appreciated.