For the following arrary: 1 a 2 b 3 c -- Thanks!

For the following array which has been named "test": 1 a 2 b 3 c 4 d 5 e I wrote the following if and lookup functions in cell A1, "=IF(A2 = " ", " ",...

Hi! Is there any way to use conditional format to make the cell black, when the formula results of cells are #N/A. Thank you very much! Ken

Hello, I have a spreadsheet which returns live market prices. From time to time I receive an error as the price is no available, the error I receive is #N/A...

I am using a spreadsheet with multiple sheets and using the Vlookup formula to pull certain data from the sheets. The VLookups are working fine, but I then...

I used the suggested function =IF(ISNA(C81),"0",C81) which worked fine. However, the following formulas resulted in an answer of "0" which was incorrect. ...

hi, i have a small problem with this...

I searched a the "Correct #N/A Error" threads and found some info on isna and iserror, but I must be doing something wrong. For any item that is not found in...

Good afternoon I am trying to use a match index formula to pull up serial numbers. The problem I am having is that if it doesn't find a match, it is...

I have approximately 10 spreadsheets in which people from multiple locations enter in savings data each month. There are two columns of particular interest in...

I have approximately 10 spreadsheets in which people from multiple locations enter in savings data each month. There are two columns of particular interest in...

Hi, Here is my problem, I import a txt file wich the number of rows varies. And I want to make a macro that plot the ''good'' value. I tried to put #N/A...

I'm using VLOOKUP and its working great, however, when there's nothing in the cells the formula is looking up, the cell contains #N/A. I'd like not to see...

Hai, like we opt to hide zero values, is there any way to hide #N/A (as a result of a funtion or formula) values in an excel sheet? Trivikram.

Hi all Is there anyway when doing a vlookup to tell excel if the value you are looking up does not exsist to give 0 instead of just getting a #N/A ref, to...

I am using a Vlookup command and getting a #NA error, instead i want the value 0. i know that there is a if(isna(vlookup....0) formulae but i have three...

I have a VLOOKUP that checks the information of 2 cells against a table to determine the proper information to be displayed. It works fine except when there is...

I have some lookup data in blank fields. If there is no data, then #NA is displayed, how can I hid the #NA without affecting the look...

Hi Is there a way to check that if a vlookup command returns a NA then it puts in a 0 not a NA? I have a list where I run vlookups but if the reference does...

I cant figure out why I am getting the #NA error with the below formula. There is data to match the critera in the formula...