Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Complicated lookup/match fuction
Hello, I am a intermediate Excel user. I would like to implement a formula to implement the following functionality in my worksheet: * I have a rating scale of 1-10 for some KPIs. * I have a list of KPIs with different rating criteria, each needing to be rated according to the 1-10 scale. I am trying to setup something whereby: * A value/result for a KPI is manually entered into a cell. * The next cell then automatically converts the value into a rated equivalent. I think I need to try and use the 'match' function, but do not understand how to use it. Can anyone possibly assist me? Thank you in advance. -- keysersoze |
#2
|
|||
|
|||
keysersoze Wrote: Hello, I am a intermediate Excel user. I would like to implement a formula to implement the following functionality in my worksheet: * I have a rating scale of 1-10 for some KPIs. * I have a list of KPIs with different rating criteria, each needing to be rated according to the 1-10 scale. I am trying to setup something whereby: * A value/result for a KPI is manually entered into a cell. * The next cell then automatically converts the value into a rated equivalent. I think I need to try and use the 'match' function, but do not understand how to use it. Can anyone possibly assist me? Thank you in advance. How about a little more detail? -- Azrael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complicated Formulas | Excel Worksheet Functions | |||
IF fuction and format ... | Excel Worksheet Functions | |||
Complicated Formula | Excel Discussion (Misc queries) | |||
How do you create a complicated pivot table graph? | Charts and Charting in Excel | |||
Page Number Fuction | Excel Discussion (Misc queries) |