The_Rock
Board Regular
- Joined
- Jul 2, 2007
- Messages
- 174
Hi Folks
I'm trying to apply ISNA to the following:
I tried
but that made all the results blank.
Appreciate any ideas. Thanks
I'm trying to apply ISNA to the following:
Code:
=IF(VLOOKUP($D2,Ineligible_Products,5,0)="Ineligible",1,"")
I tried
Code:
=IF(ISNA(VLOOKUP($D2,Ineligible_Products,5,0))="Ineligible",1,"")
Appreciate any ideas. Thanks