I've created a table similar to a mileage chart to score different shop
performance figures

Eg.

*Score*, *Revenue, Sales per opening hr
R, SPOH*,
A, 1000, 5,
B, 800, 4,
C, 700, 3,
D, 600, 2,
E, 500, 1,
F, 400, 0,

There are 6 "score grades" A to F & 11 key performance indicators (each
with their own unique abreviated header - e.g. SPOH)

I want to return a score for each store for each indicator depending on
each stores result.

Eg.

Shop 1 - Revenue is 550 - Score for this would be E as the value is
greater then 500 & less then 600.
Shop 2 - Revenue is 800 - Score for this could be B as the value is
greater then/= to 800 & less then 1000.

Would it be the INDES & MATCH function i'd need to use for this?? I
can't figure out how i'd use that to return a grade A to F?


--
loscherland
------------------------------------------------------------------------
loscherland's Profile: http://www.excelforum.com/member.php...fo&userid=6709
View this thread: http://www.excelforum.com/showthread...hreadid=533663