use the vlookup formula

=Vlookup(Barsize,Table,2,False)

where table represents a reference to the table you show. If it were
Sheet2!A2:B7 and in sheet1 you entered a bar size of 4 in cell D9

=if(Sheet1!D9="","",Vlookup(Sheet1!D9,Sheet2!$A$2: $B$7,2,false))

--
Regards,
Tom Ogilvy

"steve" wrote in message
...
i have a chart, one column asks for the bar size, the other for the pounds
per foot. i want the user to just have to fill in the size, then the
pound
per foot will be filled in automatically. here is how the lists go.....

Bar Size pounds per foot
3 .376
4 .668
5 1.043
6 1.502
7 2.044
8 2.670