................A........B.....C....D.....E.....F. ....G..................H..................I....... .......J


1.......................40...38...36...34...32...3 0......ENTER ROW
WITH.....................36
2.............115.....88...84...79...75...70...66. .....ENTER # PLANTS/
10' ROW.......76
3.............110.....84...80...76...72...67...63. .....POP PER
ACRE........................... ?
4.............105.....80...76...72...68...64...60
5.............100.....77...73...69...65...61...57
6...............95.....73...69...65...62...58...55


OK I have a table and I want to find the answer that is in the A
column. In row 1 is the different planter spacings for planting
soybeans 40 inches to 30 inches. Below those numbers are a table that
is how many plants are in 10 feet of row.
The numbers in the A column are the population per acre of plants.

I know and have entered (36) the row width in J1, I also know and have
entered (76) the number of plants in J2, I don't know how to write the
formula to give me the answer in J3 that would be (A3=110).
This is a pretty big table I am working with, the above is just a
sample.

Any help on this would be great. I am not good at explaining on paper.
Thank you
JoeBed


--
JoeBed
------------------------------------------------------------------------
JoeBed's Profile: http://www.excelforum.com/member.php...o&userid=21368
View this thread: http://www.excelforum.com/showthread...hreadid=376378