I need help or ideas

  • Thread starter Thread starter Nichole
  • Start date Start date
N

Nichole

I will try to explain this the best that I can. I have a
table that is used to score credit. Based on a person's
BNI and Beacon score, they are assigned a letter grade. I
would like somehow to have the loan officers only have to
type in the persons BNI and Beacon score to get a grade
instead of having them look it up themselves. Here is an
example of the table.

BNI
300-297 296-292
Beacon >=690 A+ A+
689-680 A A


I hope this makes sense. Like I would just want to have
them type 299 for BNI and 682 for Beacon and have the
letter A pop up for their grade. I would appreaciate any
ideas. Thanks.

Nichole
 
You can do that with something like

=Index(table,match(Beacon Score, Column1 of Table, 1),Match(BNI, Row1 of
Table,1))

You will need to look in help at the match function with 1 as the third
argument to see how it operates. Then you need ot setup you BNI numbers so
there is a single number in each cell which gets you to the correct column.
You would need to do the same think in the Beacon Column to get you to the
correct row. Using 1 as the third argument allows that; match finds the
largest cell that either matches the criteria or is below the criteria/seach
value. So a less than or equal to is implicit.
 
This is easy! In the Excel help system, take a look at the LOOKUP, VLOOKUP &
HLOOKUP functions.
 
Back
Top