Home |
Search |
Today's Posts |
#1
|
|||
|
|||
if isna and vlookup together
Hi
I have a vlookup formula where some answers are #n/a to tidy up i have used if isna the formula is quite long is there a better way than formula below i.e do I have to write vlookup again? =if(isna(vlookup(a1,sheet2!a:b,2,false),0,vlookup( a1,sheet2!a:b,2,false)) Thanks Tina |
#2
|
|||
|
|||
Tina,
Another way is something similar, that is test the lookup values for error =IF(ISNUMBER(MATCH(A1,Sheet2!,A;A,)),... not really much different. -- HTH Bob Phillips "tina" wrote in message ... Hi I have a vlookup formula where some answers are #n/a to tidy up i have used if isna the formula is quite long is there a better way than formula below i.e do I have to write vlookup again? =if(isna(vlookup(a1,sheet2!a:b,2,false),0,vlookup( a1,sheet2!a:b,2,false)) Thanks Tina |
#3
|
|||
|
|||
=if(countif(sheet2!a:a,a1),vlookup(a1,sheet2!,a:b, 2,0),0)
HTH Jason Atlanta, GA -----Original Message----- Hi I have a vlookup formula where some answers are #n/a to tidy up i have used if isna the formula is quite long is there a better way than formula below i.e do I have to write vlookup again? =if(isna(vlookup(a1,sheet2!a:b,2,false),0,vlook up (a1,sheet2!a:b,2,false)) Thanks Tina . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|