Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Complicated lookup/match fuction
Ok... please look at the following using the 'Courier' font: KPIs | Rating scale | Entered | Rating | | value | eqivalent +----+----+----+----+----+----+----+----+----+----+ | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ------+----+----+----+----+----+----+----+----+----+----+---------+----------+ KPI 1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | | | KPI 2 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 99 | | | KPI 3 | 0 | 5 | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45 | | | ------+----+----+----+----+----+----+----+----+----+----+---------+----------+ I enter a value for a KPI in the 'entered value' cell. Then, automatically, the rated equivalent appears in te 'Rating equivalent' cell. eg: For KPI 3, I enter '15'. The rating equivalent should be '4'. Any help would be greatly appreciated. -- keysersoze |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complicated lookup/match fuction | Excel Worksheet Functions | |||
Complicated Formulas | Excel Worksheet Functions | |||
IF fuction and format ... | Excel Worksheet Functions | |||
How do you create a complicated pivot table graph? | Charts and Charting in Excel | |||
Page Number Fuction | Excel Discussion (Misc queries) |