Steve,

If you can determine a mathmatical relationship - than you can just build a
formula based on the value of D7. I build a scatter plot and found that
most of the values matched a powered trend line.

But the easiest would be to use a Lookup Table. (table = $BV$1:$BW$11)
=LOOKUP($D$7,BV1:BW11)

Note that it will return #N/A if D7 isn't found.

You can get around that with
=IF(ISNA(MATCH($D$7,BV1:BV11,0))=TRUE,"",LOOKUP($D $7,BV1:BW11))

Otherwise you can use a Case Select in code.

--
steveB

Remove "AYN" from email to respond
"steve" wrote in message
...
i use the following if statement in my sheet:

=IF(D7=3,0.376,IF(D7=4,0.668,IF(D7=5,1.043,IF(D7=6 ,1.502)))))

the problem is that 7 IF statements is the max, and i have 11 that i need
to
use. do i need to switch to a macro? here is how the list goes. the
first
column is the size of the bar, the second column is the weight(pounds per
foot)

3 .376
4 .668
5 1.043
6 1.502
7 2.044
8 2.67
9 3.4
10 4.303
11 5.313
14 7.650
18 13.6