Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup question
HI Group,
I have been asked to work out a risk assessment based on some of the following grid/variables (there are 3 more to build...) Loan Rating Weight Item Rating Weight 10000 1 4 Capital 1 3 25000 2 4 Revenue 2 3 50000 3 4 Unknown 3 3 75000 4 4 100000 5 4 1000000 6 4 For example, If an applicant has the following criteria... Loan Item 15000 Revenue ....then the risk rating is (2 x 4) + (2 x 3) = 14 I have done a bit of searching and think I need Vlookup but I am not sure to implement the logic. Can someone help. Thanks Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP() Question | Excel Worksheet Functions | |||
Vlookup Question | Excel Programming | |||
Vlookup Question | Excel Programming | |||
vlookup question | Excel Programming | |||
VLookup Question | Excel Worksheet Functions |