VLookUp / INDEX MATCH "" / Null / 0 values

[Guest]

I need a bit of assistance with this one. Can someone modify these functions to accomodate "", NULL or 0 so not to have the #N/A error

1.) =VLOOKUP($A5,MyList,2,FALSE

2.) =INDEX([Book1]Sheet1!$A$1:$D$6, MATCH(A1,[Book1]Sheet2!$A$1:$A$6,), MATCH("MyList",[Book1]Sheet2!$A$1:$D$1,)

Thanks before hand for any assistance rendered.

 

[Frank Kabel]

Hi Terry

I need a bit of assistance with this one. Can someone modify these
functions to accomodate "", NULL or 0 so not to have the #N/A error?

1.) =VLOOKUP($A5,MyList,2,FALSE)
=IF(ISNA(VLOOKUP($A5,MyList,2,FALSE)),0,VLOOKUP($A5,MyList,2,FALSE))


2.) =INDEX([Book1]Sheet1!$A$1:$D$6,
MATCH(A1,[Book1]Sheet2!$A$1:$A$6,),
MATCH("MyList",[Book1]Sheet2!$A$1:$D$1,))

=IF(ISNA(INDEX(.....),0,INDEX(....))

Frank