Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thanks. Can you help me once more?
How do i copy the formula down about 80 rows? "Henry" wrote: You can do this with the LOOKUP function. You will need a table with the values that are in the drop down list and their corresponding values. Here's an example: Put the drop down list items in column X (i.e. in X1 enter Mega 423, in X2 enter Primus 220, etc.) In column Y, list the corresponding values for each (i.e. in Y1 enter 0.8, in Y2 enter 1.2, etc.) Assuming you have a total of 14 lines of data, you would then enter this formula in cell F3: =lookup(E3,X1:X14,Y1:Y14) One caution: The lookup function expects the items in column X to be in alphabetical order. This may be a different order than in the drop down list, but that doesn't matter, the two are not linked. I think that should do it. Henry "Smarty" wrote: I am trying to create a formula that does the following: Cell e3 is a drop down list with appro. 14 entries. I want cell F# to return a value based on the entry i select in E3. eg. If I choose Mega 423 from the drop down list i want 0.8 to appear in F3. The same will apply for E4 as well, but I may choose Primus 220 which has to return a result of 1.2. Can anyone advise. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |