A point in the right direction is greatly appreciated:
I have a user form that I have created and there is a score field that a user can enter a value from 0 - 100 called txtScore and the result field is txtResult.
If the value in txtScore is between 0 - 49 the value in txtResult is Critical
If the value in txtScore is between 50 - 75 the value in txtResult is Amber
If the value in txtScore is between 76 -100 the value in txtResult is Develop
I'm struggling a little bit to get it to work - In an excel spreadsheet I got it to work by looking at a sheet called LookupLists old but I am struggling to do something similar in the user form;
=LOOKUP(2,1/('LookupLists old '!A3:A5<=F21)/('LookupLists old '!B3:B5>=F21),'LookupLists old '!C3:C5)
Performance Bandings:
A B C
Lower Higher Comment
3 0% 49% Critical
4 50% 75% Amber
5 76% 100% Develop
Please can anyone point me in the right direction of how I should be going about it so I can research it?
Many thanks
Bookmarks