Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formulas
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formulas
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Array Formulas to Regular Formulas | Excel Worksheet Functions | |||
E2007 formulas display as formulas, not results | Excel Worksheet Functions | |||
Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) |