In the following formula I am getting back a #N/A
Thank you!
Excel Formula:
=IF(C2="","",
IF(AND($F2="Add",LEFT(INDEX('[Report.xlsx]Attributes'!$I:$I,MATCH(E2,'[Report.xlsx]Attributes'!$B:$B,0)),10)="DO NOT USE"),"'Do Not Use' - please make alternative selection",""))
Thank you!