how to get rid of #NA?

excelqueen · May 5th, 2002, 05:55 PM

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 · May 5th, 2002, 06:00 PM

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

You can use...

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

excelqueen · May 5th, 2002, 06:07 PM

Thanks Dreamboat. That works

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

Anne Troy · May 5th, 2002, 08:43 PM

May 5th, 2002, 06:00 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	What would you like it to do for you if the alternative is #N/A? You can use... =if(isna(myvookuphere),"whatifisna",myvlookuphereagain __________________ ~Anne Troy

May 5th, 2002, 08:43 PM	#4
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	__________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 5th, 2002, 05:55 PM	#1
excelqueen New Member Join Date: May 2002 Posts: 18	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!

May 5th, 2002, 06:07 PM	#3
excelqueen New Member Join Date: May 2002 Posts: 18	Thanks Dreamboat. That works I've set it to " "(blank) if it's NA#