If number in sheet is X pull numbers from table in different sheet matching X

[sniderza]

If a yield goal (H4) is assigned in sheet 4 or "Input costs" I want to pull information from table in sheet 1 or "fertilizer recommendations" specifically say I pick a yield goal of 140 in "Input Costs" I want to take gallons of 28% and lbs of potash from sheet 1 or "fertilizer recommendations" and put them in the corresponding cell in sheet 3 or "rates" so gal of 28% with a yield goal of 140 will appear in sheet 3 "rates" in cell B4 "gal of 28%" and lbs of potash with yield goal of 140 from sheet one will appear in sheet 3 "rates" B6.

thanks for any help!

[Jacc]

How about this?

Put this in cell B4 in sheet "Rates"

Please Login or Register  to view this content.

and this in cell B6 in sheet "Rates"

Please Login or Register  to view this content.

[sniderza]

Formula contains an error!!

[sniderza]

Found this in another thread looks kinda simalr??


Re: Find production data from one sheet a have it populate on another
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.

[Jacc]

The error is most likely that the ; should be replaced with , .
Different standards depending on local settings.

[Jacc]

Glad to hear it worked! (PM)
Don't forget to mark it SOLVED when solved. It's under Thread Tools on the top of the thread. Only you or moderator can do it.