how to get rid of #NA?

[excelqueen]

I am using LOOKUP function to autofill cells, based on the selection of other cells in the same row.

The problem is that if nothing is selected in the corresponding cells it shows #NA in the autofill (where i am using the LOOKUP function) cells

Is there a solution to this problem? Thanks in advance for your help!

 

[Anne Troy]

What would you like it to do for you if the alternative is #N/A?

You can use...

=if(isna(myvookuphere),"whatifisna",myvlookuphereagain

 

[excelqueen]

Thanks Dreamboat. That works

I've set it to " "(blank) if it's NA#

 

[Anne Troy]