returning

The formula below which is located in may places of my worksheet, populates all numbers that it finds from the Table worksheet unless the value in the Table is "0". What would cause that? =IFERROR(VLOOKUP(F2,Table!$A:$AM,26,FALSE),IFERROR(VLOOKUP(H2,Table!$A:$AM,26,FALSE),0))

Hi, I have written an Index Match Match formula but it is returning zero instead of the correct figure. I have checked the formatting and when I minus one from the other, it returns TRUE so the formatting is fine. However, it is returning zero instead of the answer. I cant figure it out...

hello, my first post here, after many years of browsing and finding solutions! I hope someone can help. I am struggling to upload the image to the post but it can be found here: https://imgur.com/a/KJbTMg1 https://imgur.com/a/KJbTMg1 I am trying to get cell F6 to return a value from the...

Hello, I have the following number in A2 123650201807171147, the middle element is a date 20180717,which i am trying to pull out using the following formula =DATE(MID(A2,13,2),MID(A2,11,2),MID(A2,7,4)) however it is returning the date 08/01/1923, instead of 17/07/2018 Any ideas what i am...

Hello all I am using the below formula to return today's date: =IF(B2<>"",IF(AF2="", NOW(),AF2),"") I have also enabled iterative calculation so that it acts as a timestamp however the formula keeps returning the date 00/01/1900. Does anyone know why this may be? Thanks

I ran into a very odd Excel quirk in which I was using this formula: =IF(ISNA(VLOOKUP(A2,$q$2:$q$33,1,FALSE)), "Yes", "No") For themajority of the column, this was returning correct results but I discovered afew instances where an exact match was returning "No". Theywere absolutely exact and I...

im trying to add together the numbers from "data" sheet c3:c383 if it matches the 2 criteria's $B$101&$B105 if it finds them in the data sheet data!$A$3:$A$383&data!$B$3:B$383,0) the formula i have is -...

Hello All, I have a working macro with vlookup function however if vloopkup find empty in the source data then it is returning 0. Can somebody help me to not to return 0 but nothing in the following code Range("AQ2:AQ" & LastRow).FormulaR1C1 =...

Hi: I have in sheet named PT balances laid out as: Col C Col D Col E Oct 2017 $1,200.00 Nov 2017 1,000.00 I want to sum data into sheet 2 I8 =SUMPRODUCT(('PT balances'!$C$4:$C$23={"Oct","Nov","Dec"})*('PT balances'!$D$4:$D$23="2017")*'PT...

Hi All, I have the following search formula in Cell F1, which works great and enters "A1"value if true and "blank" if false. =IF(ISNUMBER(SEARCH(G1,B1)),A1,"") However when i change the "within text" to look at more cells in the same row, the formula doesn't work. See example below...

Hello: I have a pivot table with Jan...Dec in A6 to A13 and Sum of Amounts in D6 to D13. I want the add sum of amount for Jan, Feb and Mar in I9. The formula below is returning zero. =SUMPRODUCT(($A$6:$A$13="Jan")*($A$6:$A$13="Feb")*($A$6:$A$13="Mar")*($D$6:$D$13)) Could you help me fix...

hello all, I am trying to use excel to make polynomial trend (2ª order) of given data. Linest function is returning "#VALUE". xls file in attach: https://ufile.io/6c91i thanks in advance

Hi - I've been struggling with this for a while and can't figure out what I'm doing wrong. (I also can't figure out how to embed images here and I've reached *maximum stress*, so I hope it's ok that I linked to G drive to show you my screenshots) I want to pull only rows from one worksheet that...

I have a calculated field in a pivot table that is returning the #DIV/0 error. There are no 0's in the field and it's a numeric field so why would I be getting this erro?. I'm simply dividing delivery cost by the number of therms.

Hi People I am having a strange time with a scoring tool that i'm using. There are two tabs - 1 with the data set (MSNA) the other providing a analysis (Family) with calculations to provide a family with a score. But, a handful of rows on the scoring tab are returning #N/A errors - this...

Hi this first one works right. =(SUMIFS($BZ$6:$BZ$77,$B$6:$B$77,"Carpenter")+SUMIFS($CD$6:$CD$77,$B$6:$B$77,"Carpenter"))/(BZ82+CD82) This is doing the same, but I needed it from a different sheet. Its returning #DIV/0! and cant figure out why. =(SUMIFS('Trade Templete'!$C$3:$C$68,'Trade...

Have the following formula returning FALSE, =IF(D11=225,F11=100,"") Not sure what I am missing again. Thanks Everyone

Good morning, This is an odd one, and I am not putting it in the right words to find elsewhere. I am working on a sheet with numerous Index/Match and Nested IFs. All of these return "" with no manual data entered. The problem is that some of the formulas are comparing the values in some...

The following formula exists in cell G2 =IF(C2<1,"",IFERROR(LOOKUP(2^15,SEARCH(Table!$A$2:$A$42000,A2),Table!$A$2:$A$42000),"")) The contents of cell C2 is “2” The expected result for cell G2 is a blank cell but the formula is returning “0”

Good afternoon, I am running an INDEX and MATCH formula however it is returning "0" instead of leaving the cells "Blank" (when it is BLANK) I am looking for some advice please The formula is below...