VLookUp / INDEX MATCH "" / Null / 0 values

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Hi Terry
Terry said:
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,))
Click to expand...
=IF(ISNA(INDEX(.....),0,INDEX(....))

Frank
 
Back
Top