#value

Hi all! I am having an issue with XLOOKUP and VLOOKUP and can't figure out if it is a formatting error with the text, specifically the 'XH' at the start of the text To my eyes, I have checked the data set both sides and the format is the same for both so the lookup's should work The formula...

Hello Sir/Madam, I have multiple excel files in folder contains multiple sheets. I'm looking for macro to run on those and find if any #N/A , #NAME?, #VALUE!, #REF! and provide excel name if any contains this.

I need to change a group of values to value A, and another group of values to value B Below is what I have so far, and the code is not working. what am I doing wrong? Sub CleanUpOutlier() With Range("D1", Cells(Rows.Count, "D").End(3)) .Replace "F21222CJ-08"",F21222CJ-11"""...

Please god someone give me some ideas because at the moment it looks like Excel is just screwing with me... I haven't posted on this account before but no stranger to Excel, VBA or Formulas. Running Windows 10, Office 365. So, I have a biiig horrible formula with lots of things nested all over...

Hi, I am not sure if there is a solution to this. I have a Workbook where I capture information. I have added some formulas ease the process. I have a Dashboard Worksheet that summarize some data. The formula is [COUNTIFS('Incident Register'!$B$5:$B$2001,'Data Sheet'!A4,'Incident...

I am fairly new to VBA. I need to create a macro that searches the entire column K for keywords " C Box", for any cell in this column that contains these keywords, I need to add a numerical value to the end of the text (this numerical is always in the same row as the cell that contains the...

HI all, I'm new to this forum so forgive me if my question has been answered before, but I searched the FAQ and I didn't find an answer. I'm creating an Excel function to perform a statistical test. Basically, the input is a range of cells containing my data set. Then I create an array with...

Hi, I have an issue, i though pretty simple one but cant handle it so i guess was wrong. I have a UDF that calculates average of exchange rates between 2 dates Option Explicit Public Function averageFromRange() As Double Dim sh As Worksheet Set sh = ThisWorkbook.Worksheets("Exchange...

In xlookup you can define what your error response is ~~ =xlookup(a3,b:b,c:c,<whateveryouwantyourerrorresponsetobe>,option,option). Typically I use "" as my error response. However when you copy the cell and paste as value (the result being an error state equaling "") in another cell...

Hi I want to see if column A+B can find a match against columns D+E Any help would be appreciated Thanks

Hi All I am currently using the below function to show if a row is hidden or not, when i first use the function it works perfectly but as soon as i unhide/hide a row all the values change to #VALUE . What am i doing wrong? Public Function isvisible(rng As Range) isvisible = Not...

I have the following formula that is giving me a #VALUE ! error and I've been looking at it so long I can't see where the syntax is wrong. Can someone please help? =IF(AND(Y17="Replacement2",Z8<3),"Wave "&'Project Data Sheet'!J73&" Print Order","Wave "&'Project Data Sheet'!B101&" Print...

I am getting #VALUE error the below COUNTIFS formula, tried various possible changes based on research, but nothing works =COUNTIFS($G$2:$G$2184,02.11.2019,$I$1:$I$2184,Resolved) Both conditions work when used independently

Hi +$d$8 (where the date is in a date formated field) +(g17x7) does not work. G17 is weeks post award. 7 (days of the week) all I keep getting is value. I tried in a different cell +$d$8+14 and that failed too. Anyone know why? I get the usual hopeless #value MS message. Thanks

Hello forum friends, Can someone please tell me why this formula is giving me the #VALUE ! error? "&TEXT(D36/(tax_tables!C39),"0%")&" The value in D36 is $1227.32 and the value in tax_tables!C39 is $1154.58. I want to display the result as a percentage. The formula is a smaller part of a...

how do you incorporate the search & or function into the same formula? i keep getting #Value with my formula. Any help is appreciated. =if(search(or("Best","Good","Average"),A1,1)=1,"Pass","Fail") Thanks.

Hi, I'm trying to return the value of a couple cells, depending upon whether or not they contain a value. I'm using the formula below: =IF(OR(IF(NOT(ISBLANK(SEARCH($BP$2,B2))),$BP$2,""),IF(NOT(ISBLANK(SEARCH($BP$3,B2))),$BP$3,"")),"") The idea is that either BP2 or BP3 will contain a value...

Hi, I have this IF formula but give me error "#VALUE!" here is the code: =IF(AND(L4="AB/BC","QC"),K4/1.05,K4/1.13) here is the data:

Trying to use mode on data with negatives times. <colgroup><col span="2"></colgroup><tbody> -0:11 #value ! -0:06 #value ! -0:03 #value ! -0:05 #value ! 0.01 0:08 0.00 0:00 0.00 0:01 The #value is removing the seconds if present formula INT(CJ15*1440)/1440 I'm removing seconds...

Hi, I have a long formula and have taken snapshots of the last steps in the evaluation chain: https://imgur.com/a/5z2NzW3 The formula identifies the value I am looking for but in the end it returns #value error. Can I please have some guidance on how to solve this issue? :(