excel - Conditional results based on average found from other cells -

excel - Conditional results based on average found from other cells -

rather excel formula of kind:

=if(average(a1:a4)<4,"poor",if(average(a1:a4)<5,"meet expectation",if(average(a1:a4)<7,"good",if(average(a1:a4)<8,"excellent","outstan‌​ding"))))

how might accomplish similar results lookup table?

with lookup table (and without requiring exact match):

where exacct match not found defaults next lower matching value. 9 can not found 8 can be, hence outstanding. have not been specific breakpoints (eg 5 seems both meet expectation , good) table easy adjust suit adding or deducting little amount number left of good.

the table here named qarray , can placed anywhere in same workbook if named range of workbook scope.

excel excel-2007 vlookup worksheet-function