ISNA question
 

Not really sure how ISNA works completely...
here is my formula-
=VLOOKUP((CONCATENATE(C6," ","Average")),TURNS,2,FALSE)

is it-
=(isna(VLOOKUP((CONCATENATE(C6,"
","Average")),TURNS,2,FALSE)),"0",VLOOKUP((CONCATE NATE(C6,"
","Average")),TURNS,2,FALSE))

if its NA i want it to be a 0

Mark

I think you are just forgetting the IF...

=IF(ISNA(VLOOKUP(CONCATENATE(C6,"
","Average"),TURNS,2,FALSE)),"0",VLOOKUP(CONCATENA TE(C6,"
","Average"),TURNS,2,FALSE))

Regards,
KL

"ShineboxNJ" wrote in message
...
Not really sure how ISNA works completely...
here is my formula-
=VLOOKUP((CONCATENATE(C6," ","Average")),TURNS,2,FALSE)

is it-
=(isna(VLOOKUP((CONCATENATE(C6,"
","Average")),TURNS,2,FALSE)),"0",VLOOKUP((CONCATE NATE(C6,"
","Average")),TURNS,2,FALSE))

if its NA i want it to be a 0

Mark

Sorry, another one:

Do you really intend to return 0 as text in case of error? If not, then
change "0" to 0:

=IF(ISNA(VLOOKUP(CONCATENATE(C6,"
","Average"),TURNS,2,FALSE)),0,VLOOKUP(CONCATENATE (C6,"
","Average"),TURNS,2,FALSE))

KL

"KL" wrote in message
...
I think you are just forgetting the IF...

=IF(ISNA(VLOOKUP(CONCATENATE(C6,"
","Average"),TURNS,2,FALSE)),"0",VLOOKUP(CONCATENA TE(C6,"
","Average"),TURNS,2,FALSE))

Regards,
KL

"ShineboxNJ" wrote in message
...
Not really sure how ISNA works completely...
here is my formula-
=VLOOKUP((CONCATENATE(C6," ","Average")),TURNS,2,FALSE)

is it-
=(isna(VLOOKUP((CONCATENATE(C6,"
","Average")),TURNS,2,FALSE)),"0",VLOOKUP((CONCATE NATE(C6,"
","Average")),TURNS,2,FALSE))

if its NA i want it to be a 0

Mark