returns

Hi all, I hope you can help as I appear to be missing something. I have a value in CALC!C8 which I am trying to look up. =VLOOKUP(CALC!C8,VALIDATION!A6:C10,3,0) So in the VALIDATION SHEET A6 =0% B6 =50% C6 =1 A7 =50.01% B7 =60% C7 =2 A8 =60.01% B8 =65% C8 =3 A9 =65.01% B9 =70% C9 =4 A10...

I am trying to match 3 rows of data with data in another tab ('1'). For some reason, some of the returned values are correct . . . but some are returning the results from a different row. {=INDEX('1'!$R$5:$R$55,MATCH(C71&D71&E71,'1'!$A$5:$A$55&'1'!$B$5:$B$55&'1'!$C$5:$C$55),0)} When it looks...

Hello, I have one column that gets a text based value with an if statement, and I'd like to count how many times something returns. However, while I do the countif function on that column it seems like it doesnt read that text or something. Any tips? Thanks!

I have a column of alphanumeric values separated by commas (and maybe a comma followed by space) that I'm wishing to return the array position (or row number). Formula input "3" would return 1, input "6" returns 4. The problem I'm having is the formula below is returning 3 for input of 6...

Hi I've got a spreadsheet with a list of data in column H and I'd like to use VBA to return a value in column O that is dependent on the value in column H. I’d like to search the text using the instr (in string) function then return a value if specific text appears. Conditions: If a cell...

Hi, Trying to retrieve the number of months between the two dates below. Dates are generated through functions beneath. 2019-01-01 A1=DATEVALUE(YEAR(TODAY())&"-01") 2019-04-01 B1=EDATE(DATEVALUE(MID($C$12;18;4)&"-"&MID($C$12;23;2));1) =DATEDIF(A1;B1;"M") does not work, returns "1900-01-03"...

Hi I understand that workbooks.open returns a workbook object. So it returns something and because of that, I thought it should be call using ( ) for example workbooks.open("abc.xlsx"), but the author of this link https://analysistabs.com/excel-vba/open-close-existing-workbook/ called...

I can't get this formula to return value 99 if cell C10 is blank: =IF(AND(B10="H",C10=0),"99",C10) I've tried this: =IF(AND(B10="H",C10=""),"99",C10) and this: =IF(AND(B10="H",trim(C10=0)),"99",C10) The formula only returns the contents of C10 if C10 is populated, but it doesn't return value...

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

Hi I've got three formulae that work in isolation, but not together. If the text "4 for 10" is in cell A1, I'd like one formula that returns the text "Multi deal where X<Y" if 4 is greater than 10, which it is. But returns "Multi deal where X>Y"if the text in cell A2 was 10 for 4. The...

G'day Magicians I have a column with around 100,000 dates in it mostly from the last one year period. I would like a formula to put into the next column that returns an "O" if the day was an odd number or an "E" if the day was an even number . for example 04/04/2019 O and 05/04/2019 E...

Hi Everyone, First off I wanted to thank everyone for the forum... This place is awesome.. I am learning a lot thanks to all you guys!!! I have monthly returns and wanted to calculate a 3 & 5 Year annualized return. Could anyone help me? Please see attached 31-Jan-14 0.71 28-Feb-14...

I have a price point available with me from 1979 to 2018. I am looking to calculate the rolling return of this years for 1/2/3/5 Years period. Also, This returns I am looking in Percentage terms. Please advice right method

Good afternoon, I am having trouble with the formula... =COMBIN(L$4,C14)*COMBIN(L$5-L$4,0)*COMBIN(L$6,E14)*COMBIN(L$4,E14-1) It returns a #NUM ! error. Thanks in advance.

<tbody> a b c d 1 5 2 7 100 2 10 4 14 200 3 15 6 21 300 4 2 8 28 400 </tbody> If I have a table like the one above with column and row headers...NB. these are not the Excel headings, they are specific to the table and could appear anywhere on a worksheet. I...

When using filters on columns I was taught it's better to use the text filters than unchecking items. So my rule of thumb has always been to use "or" versus "and" because AND means both criteria have to be met to exclude the row OK so today I have a list of fund numbers (coded as text) 1, 2...

Hey guys, I am using the dateadd funtion to add weekdays to my date, but it appears to be including the weekends as well. Can you help?? I am attempting to add 25 weekdays (Mon-Fri) to the reservation_date field. When I use the funtion below, it returns the date plus 25 days... Dateadd("W"...

Hi I have the following code which works great based on the Role columns in a table being "Yes" Looks up the nth occurrence of, A5 =Table4[Name] B1 <= Table4[Date] B2 >= Table4[Date] Yes = Table4[Role] and returns the Table4[Ref]...

HI, I have this formula.. =IF(AND(I7>=K7,L7>=J7,),$A$16,$A$17) and if I hit the evaluate formula button and cycle through the formula the first part of the AND returns TRUE, then the second part returns TRUE, then when I click the 3rd time the result changes to FALSE? no matter what I do I...

I've inherited a workbook with a bullseye symbol in cell A1. The curious thing is that the formula bar shows nothing in the cell other than a wide space. When I check it with the formula in B1 =CODE(A1), it returns 158. When I enter the formula =CHAR(B1) it returns the character "ž". If I...