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

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