=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;
<colgroup><col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;"> <col width="64" style="width: 48pt;"...