Find production data from one sheet a have it populate on another

**mike6065** · 10-18-2012, 11:33 AM

I am trying to pull production data from one sheet a have it populate on another. I tried using the vlookup, however it only pulls a single cell not the row nor will it pull in any other info from the main column. I have trying to figure this out for several days and it is driving me crazy. I'd appreciate any suggestions

Thanks

**jeffreybrown** · 10-18-2012, 11:36 AM

Hi mike6065,

Sounds like a vlookup could be the right function, but have you copied the formula down the column?

Maybe a little more description towards what you are trying to achieve. What columns are you referring to?

**twiggywales** · 10-18-2012, 11:36 AM

vlookup can pull more info in if you use it with a larger table and then increase the column it returns

if you upload a book i may be able to help more efficently.

(also index my be what you want as its more flexable)

**mike6065** · 10-18-2012, 01:48 PM

Originally Posted by jeffreybrown

Hi mike6065,

Sounds like a vlookup could be the right function, but have you copied the formula down the column?

Maybe a little more description towards what you are trying to achieve. What columns are you referring to?

On the first page I have 3 populated columns material number, description and weight. On the second page I have same 3 columns and scrap headings. I want to be able to popular the first column with a material number and both the description and weight would be automatically filled in. I need to be able to do this on multiple rows(up to 20).

**jeffreybrown** · 10-18-2012, 01:54 PM

On the second sheet in cell B2 enter (drag down and over)

=IF($A2<>"",VLOOKUP($A2,'First Page'!$A$1:$C$30,COLUMN(B$1),0),"")

Note: Adjust the part in red to match the size of the lookup table

**mike6065** · 10-18-2012, 05:47 PM

That is exactly what I am looking for, however the 3rd colum is not populating (weights). What am I missing?

**jeffreybrown** · 10-18-2012, 05:54 PM

Hard to say without seeing a sample, but this part increments the column return for the VLOOKUP.

COLUMN(B$1)

Put the above on your spreadsheet say in A1. The returned result should be 2. Now drag the formula to the right and it will increase up by 1.

So with the formula I proposed in B2, dragging it to the right it will look like

B2 =IF($A2<>"",VLOOKUP($A2,'First Page'!$A$1:$C$30,COLUMN(B$1),0),"")
C2 =IF($A2<>"",VLOOKUP($A2,'First Page'!$A$1:$C$30,COLUMN(C$1),0),"")
D2 =IF($A2<>"",VLOOKUP($A2,'First Page'!$A$1:$C$30,COLUMN(D$1),0),"")
etc.