Vlookup & ISNA

[The_Rock]

Hi Folks
I'm trying to apply ISNA to the following:

=IF(VLOOKUP($D2,Ineligible_Products,5,0)="Ineligible",1,"")

I tried

=IF(ISNA(VLOOKUP($D2,Ineligible_Products,5,0))="Ineligible",1,"")

but that made all the results blank.

Appreciate any ideas. Thanks

 

[PaddyD]

notwithstanding the specifics:

http://www.mrexcel.com/forum/showthread.php?t=59718

 

[T. Valko]

Hi Folks
I'm trying to apply ISNA to the following:
=IF(VLOOKUP($D2,Ineligible_Products,5,0)="Ineligible",1,"")

I tried
=IF(ISNA(VLOOKUP($D2,Ineligible_Products,5,0))="Ineligible",1,"")

but that made all the results blank.

Appreciate any ideas. Thanks

What version of Excel are you using?

 

[The_Rock]

Biff, its Excel 2010
Paddy, thanks I'll take a look. BTW I only want the action of 1 or "", if the lookup result is 'Ineligible'

 

[T. Valko]

Biff, its Excel 2010
Paddy, thanks I'll take a look. BTW I only want the action of 1 or "", if the lookup result is 'Ineligible'

Try this...

=IFERROR(IF(VLOOKUP($D2,Ineligible_Products,5,0)="Ineligible",1,""),"")

 

[The_Rock]

Thanks Biff, just what was needed

 

[T. Valko]

Thanks Biff, just what was needed

You're welcome. Thanks for the feedback!