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;
[TABLE="width: 1011"]
<colgroup><col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;"> <col width="64" style="width: 48pt;" span="2"> <col width="414" style="width: 311pt; mso-width-source: userset; mso-width-alt: 15140;"> <col width="64" style="width: 48pt;" span="9"> <col width="157" style="width: 118pt; mso-width-source: userset; mso-width-alt: 5741;"> <tbody>[TR]
[TD="width: 72, bgcolor: transparent"]Feature 1
[/TD]
[TD="width: 1275, bgcolor: transparent, colspan: 13"]Renewal Application entry - Mediator[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Feature 2[/TD]
[TD="bgcolor: transparent, colspan: 13"]Continuing Mediator Education entry - Mediator[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Feature 3[/TD]
[TD="bgcolor: transparent, colspan: 13"]Rule 31 Mediation Report entry - Mediator[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Feature 4[/TD]
[TD="bgcolor: transparent, colspan: 13"]MyData Search and update - Mediator[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Feature 5[/TD]
[TD="bgcolor: transparent, colspan: 13"]Provider New Course approval Request - Provider[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Feature 6[/TD]
[TD="bgcolor: transparent, colspan: 13"]Provider Course Attendance Update - Provider
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Feature 7[/TD]
[TD="bgcolor: transparent, colspan: 13"]Mediator Course Management - Administration
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Feature 8[/TD]
[TD="bgcolor: transparent, colspan: 13"]Mediator Communications - Administration[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Feature 9[/TD]
[TD="bgcolor: transparent, colspan: 13"]Internal Reporting - Administration[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Feature 10[/TD]
[TD="bgcolor: transparent, colspan: 13"]Online Payment[/TD]
[/TR]
</tbody>[/TABLE]
However the result I get back is Renewal Application entry - Mediator