#na

Please can someone assist, I don't think I'm a million miles away from the correct formula but I'm obviously missing something! In my formula I'm trying to combine a IF(AND with a VLOOKUP(CONCATENATE but get the return of NA, which generally I would use ISNA or IFERROR but unsure how this fits...

Hi, I have a problem with my excel formula. I first had 2 files and using vlookup I copied the data from one file to another based on the data in a cell. However I needed to change it so it all fitted in one file, so I needed 2 sheets. Problem is when I use the exact same formula I now get #N/A...

Hi There, I have an array formula which spans 250 columns and transposes a varying number of values using OFFSET as my output. When I get less than 250 values there appears an "#N/A" in the cell which can not be removed by the IFERROR method or IF(ISNA method...

Does work (regardless of C4 contents): =INDEX(Details!$J$2:$J$50000,MATCH('Vulnerator Translator'!C4,Details!$P$2:$P$5000,0)) Does not work (if C4 is a formula): =INDEX(Retina!$C$3:$C$10,MATCH('Vulnerator Translator'!C4,Retina!$A$3:$A$10,0)) However this second one will work if the content...

Can anybody tell me why this is happening? <table width="256" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="width:48pt" span="4" width="64"> </colgroup><tbody><tr style="height:12.75pt" height="17"> <td style="height:12.75pt;width:48pt" height="17" width="64"...

i have been using excel 2010 for a few days now, but i have got a few problems about vlookup and match. they just keep displaying #NA does it matter all cells are in gerenal? =VLOOKUP(M2,A2:K7,2,FALSE) M2= 55 A2:K7- A is reference number B is name D7 is same as M2 (55) the formula above...

HI Guys I have a problem i have 3 cells e.g. a1, a2, a3 and they all have specific values if filled in by employees. For example they may have a value from 1-10 or if not filled in the have the #NA value. I am looking to find the max value from this array of numbers however when i use the max...

Objective: I using a sumproduct formula to aggregate data from 2 columns in another sheet, 1 of which contains #NA values. Do the #NA values cause the sumproduct formula not to work and if yes, how can I convert the #NA's to something else. Here's the formula producing some #NA's. Formula...

I have setup an add-in containing several of my commonly used User Defined Functions. When I use one of these functions in a workbook with the add-in loaded, I just get #NAME? unless I specify the Add-in name explicitly prior to the function, e.g. =Addin.xla!FunctionName(params...) When I...