#name

Don't why there is #NAME ? error using the Morefunc (MCONCAT)? Book1NOPQR21[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL] ?[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=NAME]#NAME[/URL&rsqb...

I keep getting #NAME when I put a formula into a cell I am trying to create the following logic: If cell I2 or cell K2 is not blank, then populate with the value of C2, else, leave blank Here is my attempt at the formula below =IF(OR(I2<>"",K2<>""),C2,””) Help Please

I am getting the #NAME ? error with the formula listed below and am not sure how to fix it? I am using the same formula on another sheet within the same workbook and it is doing just fine. =IF(COUNTIFS(CA Data!I:I,CA Temp!H2,CA Data!G:G,CA Temp!F2)>=1,1,0)

Hi, I have row data that contains serial numbers in the following format "-VPT0000017J". Due to the minus upfront excel thinks this is a formula and assigns an additional "=" to the front. All and all I get an end result of "=-VPT0000017J", which is then displayed as #NAME? making it impossible...

Hi, I setup different range names that point to a different Excel file and used these different name ranges in formulas that I have in my Excel file. Each time I open this Excel file, I get the following pop-up message which I click the "Update" button to but then the "#NAME?" issue shows...

Team, I have a big issue/need to complete a DB by AM Thursday. Would someone be able to help me with this IFS statement and why it returns #name . IFS(F5=0, 150,F5<=1, (1-F5)/1*25+125,F5<=3, (3-F5)/2*25+100,F5<=5, (5-F5)/2*50+50,F5>5,0) When I recieved the Formula it was like this...

Morning guys A simple one for you experts, but not so simple for myself as a newbie to VBA. I am trying to write =IF(H2="0",H2,"0"&H2) as part of a VBA string. However, whatever I try is returning #NAME ! Any ideas on how I should write this in VBA please folks? Many thanks, Gareth

I have this formula and it's producing the #NAME? error. =IF($C74=”A”,U$79,IF($C74=”B”,U$80,IF($C74=”C”,U$81))) How do I correct this? Thanks in advance

Hi I'm running Excel 2010 and would appreciate help on a #Name error when trying to enter a formula using active cell.offset via VBA ActiveCell.Offset(0, 4).Formula = "=If(ActiveCell.Offset(0, 1)>0,ActiveCell.Offset(0, 17) / ActiveCell.Offset(0, 1),0)" The above 'works' in that a 'formula' is...

Hello, I've created several UDFs, they were working just fine, but after I saved and reopened the workbook all of them have been returning #NAME error just like Excel could not locate them. They were saved in standard code module. I've played a little bit with Excel trust settings, reopened the...

Hi, I am not sure how to put this. First time posting here, but been Reading ALOT! What im trying to pull off: i = 7 Do If i / 2 > Int(i / 2) Then Rows(i).Interior.ColorIndex = 15 End If i = i + 1 Loop Until...

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...