Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Or, if the relationship between boiler number and required dollar
amount is not as simple as it is in the example given... =VLOOKUP(A1,{"boiler 1",2000;"boiler 2",3000;"boiler 3",4000},2,FALSE) Ken Johnson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to convert a month to a quarter ...... | New Users to Excel | |||
Dropdown list | Excel Discussion (Misc queries) | |||
no show all function in dropdown list in Pivot Table | Excel Discussion (Misc queries) | |||
Data Validation - Dropdown List Not Appearing | Excel Discussion (Misc queries) | |||
self-building dropdown list | Excel Worksheet Functions |