What I am looking for is when a % is input in Sheet "Input" Cell B2, B3 Etc, a lookup on Cell B1is carried out against column "B" sheet "lookup". Then the cell "C3" in Sheet "input" is updated to "Not Compliant", "At Risk" and "Compliant" with red, amber and green fill depending upon the acceptable values in sheet "lookup" columns D, E and F
I will have a look, however please remember that we do expect a modicum of common courtesy here - 'please' and 'thank you' are universal courtesies, and you should not take the free help you may be offered here for granted.
EDIT: Please manually fill in what you are expecting to see in the empty cells and post the workbook again. Thanks.
AliGW on MS365 Insider (Windows) 32 bit
GOV.AM1 GOV.AM1.1
Sheet: Input
Last edited by AliGW; 09-20-2021 at 10:45 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
See attached: I changed the "Lookup" table
in C2
=INDEX(Lookup!$D$1:$F$1,MATCH($B2,INDEX(Lookup!$D$3:$F$9,MATCH(Input!$A2,Lookup!$B$3:$B$9,0),0),1))
ALiGW
You are of course correct and I apologise. I copied this out of an extract from something else I was doing that had the appropriate p's & Q's in.
@John Topley, This is so close it is painful
If not I will go with this solution.
Thx
See attached: add the ranges to table
in D2
=VLOOKUP(Input!$A2,Lookup!$B$3:$I$9,MATCH(C2,Lookup!$D$1:$F$1,0)+5,FALSE)
That does the job great John. Thanks for all your support.
K
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
You're welcome and thank you for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks