returning

I am pulling into cell A52 =+j12 from cell J12 thats arial font but in A52 i have the cell to script , but its now returning it in script.

Suddenly all of these formulas (like below) are no longer just returning words, they are returning 0's. All of the other cells referenced have words in them. =IF(Developer!J46="Network","C: Drive Daily Archive", Developer!E42 & " Daily Archive")

Hi All, I know this is a big ask, but I'm really having trouble evaluating a formula to determine where an error is. The formula is returning 4.5 which is the value in AQ10, but it should return a 7.5 which is the value in DashboardH8. Here is the formula...

Please forgive the noobness here. I didnt know how to sum 2 cells together at the start and managed this monstrosity after one month of free time. Cell n408 is returning the date I want and cell p408 is not. Once I understand why I can fix the rest. Thanks for any insight...

Is there a way to get a workbook to activate a certain worksheet, say Sheet1 "A1" after a set period of inactivity? Thanks Jason Bing EDIT: I know you can get a workbook to save and close after inactive time. But I need it to return to a home page?

An extension to this problem: https://www.mrexcel.com/forum/excel-questions/1107696-approximate-match-vlookup.html I want to amend this formula: =IF(C3>INDEX($I$3:$I$7,MATCH(A3&"|"&B3,INDEX($G$3:$G$7&"|"&$H$3:$H$7,0),0)),"Y","N") to this...

I have dates in Column A that are constantly being added to. I need a formula approach to detecting the last filled cell in column A (or the first empty cell in column A) and returning its row number.

Hello all, In column Y I have quote numbers. In column A I need to put the quote number from column Y if it begins with CP or DC and blank if not. I tried this but the result is not right and returning (#VALUE!) =IF(MID(Y12,1,2="DC"),Y12,IF(MID(Y12,1,2="CP"),Y12,"")) Not sure what I am...

Here is the data which I am trying to extract the dollar amount in D4 from. Excel 2016 (Windows) 32 bitABCDEFGHIJKLMNOP1Tax Credit TypeFederalNLPENSNBONMBSKABBCYTNTNU215%8.70%9.80%8.79%9.68%5.05%10.80%10.50%10%5.06%6.40%5.90%4%3-3-5-1-6-4-74Basic personal amount...

Hi: The formula below is suppose to return zero when value in B4 cannot be match to facilitate SUM calculation using B4. But, SUM formula is returning #VALUE B4 = IFERROR(INDEX(List!$N$8:$N$80,MATCH('Report2'!B4,List!$AA$8:$AA$80,0)),0) Can you help please? Regards, Sean

Hello Everyone, I was wondering if anyone might know how to return only partial data using Vlookup. I would like to only bring back the first name instead of the full name when doing my vlookup. Thank you for any help anyone can give me. Thank you. D.

Hello, I am attempting to do an IF/EXACT formula that contains two different values. Here is the formula that I've come up with, but it keeps returning a #N/A value: =IF(EXACT(G2,"B"),"Btl"),IF(EXACT(G2,"b"),"btl","")

Hi, How could I go about taking my cell value in S33 and selecting the closest greater than value in T19:T30, then returning the corresponding Overload in the column to the left of the closest greater than value? Which formulas would I use to achieve this? Thanks in advance.

Can someone tell me why this formula is returning "FALSE" opposed to "YES" or "NO" ? I have a feeling the brackets are incorrect =IF(AND(($F$2>=A4),($C$2<=B4)),OR(IF(AND(($F$2>=A5),($C$2<=B5)),"YES","NO")))

Hi: I am trying to compare data from two pivot tables. Formula below in E4 of worksheet pivot table 2 is trying to returning to return required values from worksheet pivot table 1 but Excel is returning #VALUE =INDEX('pivot table1'!$B$6:$B$49,MATCH(B5,MID('pivot...

Hi, I use the same bit of opening code on just about everything I ever work on (I know there are a lot of different ways of doing this): 'Finds last row of data on the Altos billing Nov 18 calls Sheets("Altos billing Nov 18 calls").Select LastRowWithValueAltos = Columns("A").Find("*", ...

Morning all, I'm using For Each cell in a particular column. If this value is greater than zero I need to pull in the value from column A. But the column I'm currently in will change based on which month it is. How do I return the value from Column A no matter what column I'm in. ie. if I was...

I have a list of 791 part numbers that are all 16 digits, and I'm trying to identify how many times each number appears in the list. My data is in column A and my formula is in column B. I'm using the following formula and filling it down to the bottom of the list: =COUNTIF($A$1:$A$791,A1). Some...

I have a small worksheet for an example 3 columns,6 rowss col a1=1 a2=1 a3=1 a4=2 a5=2 a6=2 col b1=1 b2=2 b3=3 b4=1 b5=2 b6=3 col c1=1 c2=1 c3=1 c4=1 c5=2 c6=2 my vlookup formula in column D =vlookup(c1,$a$1:$b$10,2,false),"") returns all 1's in col d1 through d6.....it's returning first...

I have got to be missing something simple here. I have the following code where "1" appears 3 times and "5" appears 1 time in Range("A1:A25")... =COUNTIF(A1:A25,OR(1,5)) Which I would think should return "4", but it is returning "0"... Does anyone have any input? (web searching isn't really...