Code:
=IF(Checklist!B27="","",VLOOKUP(A176,Features,2))I have the above formula on my worksheet A176 has the value Feature 10. The Named Range is the following;
| Feature 1 | Renewal Application entry - Mediator |
| Feature 2 | Continuing Mediator Education entry - Mediator |
| Feature 3 | Rule 31 Mediation Report entry - Mediator |
| Feature 4 | MyData Search and update - Mediator |
| Feature 5 | Provider New Course approval Request - Provider |
| Feature 6 | Provider Course Attendance Update - Provider |
| Feature 7 | Mediator Course Management - Administration |
| Feature 8 | Mediator Communications - Administration |
| Feature 9 | Internal Reporting - Administration |
| Feature 10 | Online Payment |
However the result I get back is Renewal Application entry - Mediator
