ISNA question

G

Guest

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((CONCATENATE(C6,"
","Average")),TURNS,2,FALSE))

if its NA i want it to be a 0

Mark
 
K

KL

I think you are just forgetting the IF...

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

Regards,
KL
 
K

KL

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ISNA Formula returning "False" instead of value 4
summing results of multiple vloopups 1
Vlook up to combine data in many sheets 1
Vlookup on more than one sheet 5
IF, ISNA & VLOOKUP 5
The code below worked for a few days and just totally stoppedworking. 1
Combine data into central worksheet 1
MONTH function 2

Top