Formula for displaying numeric value post selection of category

[Zaid]

Dear All,

I am attaching excel sheet in which Columnt C (Maturity) has list selection and then i have Column D (Score). I have defined scoring for every maturity level. Now i want that whenever i select any maturity level from list, corresponding score should come SCORE column.

Please help.

Regards
Mohammad

[benishiryo]

hi Zaid, like this perhaps in D2?
=VLOOKUP(C2,$H$3:$I$8,2,0)

[rcm]

try the worksheet

[kvsrinivasamurthy]

After slight correction this can be used.

Please Login or Register  to view this content.