excel 2016 formula issue

I need an excel formula that will match the name from column E from the first spreadsheet to the name in column C from the second spreadsheet (both in the same workbook) and return the value in column D from the second spreadsheet.

I'm trying to create a spreadsheet that counts the number of a particular occurrence on a row only when it matches the name. Cover Sheet Col A Col B Row 1 BOB =SUMPRODUCT((General!$A:$A=Cover!A1)*((General!$B:$FZ="Apple"))) Row 2 JANE Row 3 JOE Row 4 JOHN General Sheet...

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

My data looks like this: <tbody> c2=\Data Tab\Get & Transform c3=\View Tab\Show/Hide\Ruler I am looking for a function - for this example named Parse where Parse(c2,"",1) equals Data Tab Parse(c3,"",2) equals Show/Hide </tbody> Public Function separate(field As String, separator As...

I am in need of a formula that will look into column C (Last Used) and column H (Last Purchased) to determine if both dates are before 2015. If they are then an asterisk should mark the cell.

Hi! I have an Excel 2016 worksheet with a data connection to db where I query contents to Excel. It is a simple table with invoice numbers and due dates. Those are exclusively unpaid overdue invoices. SQL query identifies if the invoice is open (unpaid). The date is kept as a decimal in the...

Hi all, So i have a long column of date data (01/10/2018 etc) in Column A:A and what I'm trying to do is have Column B:B return back the following criteria: Last Week (Which is the date in A:A is in the last 7 days) Last Week -1 (Date in A:A is from the week prior to last) Last Week -2 etc...

I am need a formula that will will search column B for the words "Vendor" and "SearchTerm" and bring back the results from column C. For instance: Column B Column C Vendor 1000056 SearchTerm MCMASTERCA

Good afternoon, I have an array formula setup to bring back the earliest sell date of a product from a different worksheet in the same workbook. The formula works, but it drags Excel to a massive crawl and sometimes the program freezes up because it's currently 137,051 rows of data. Note: The...

Looking for some help with a formula that figures use tax based on type of job and state. Excel version 2016, windows 10 D4 can be install or product I currently have a working formula =IF(ISERROR(SEARCH("inst",$D4)),0,((L4+Q4)*0.06)) If D4 contains inst it will multiply cost of job by .06 to...

Hello, We import a report from a website and several of the key information get put into one cell which is very annoying. The problem is the number of characters differs in each cell. With the example below, what formula can I use to get the ":No of Delegates:" values in column B, which would...

Hello there! I'm having problems coming up with an excel formula for my office. We get 10 hours and 40 minutes a month and work 8 hour days. It needs to calculate how much time accrued as well as used from the date of hire. Any help with formatting and a formula would be greatly appreciated!

Hi and greetings, I am trying to use last years sales data to compare to this year for certain sales categories. However I need to limit the sum range of the historical data to the current week number eg week 20 as this years figures only go up to the current week eg week 20. I have a cell...

Hello (once again)! I am using some conditional formatting to highlight specific dates in a column based upon a comparison to the TODAY() function. The formula I am using in the conditional formating is: =AND($F2:$F10>TODAY(),$F2:$F10<$A$1) It is supposed to turn it yellow. It doesn't...

I have an extra helper column based on the first formula listed below, however, I would like to incorporate said index match formula within the larger sumproduct formula, and remove the helper column. The use of this index match formula is necessary since the sumproduct formula relies on two...

I have two rules in a sheet I have. Once that checks if a range of cell rows (7:446) in column D equal any of the values listed in column A of a sheet titled "required_refs". If the values in those rows do match the values in the separate sheet, it'll turn that cell to a red fill background. The...

Hello, I'm using a calculation example from accounting guidance related to direct financing leases. There is a monthly rent payment that is fixed for 9 years (10,000 per year) and an initial net investment amount of $65,100. At the end of the 9 years, the lease will have a residual value of...

This is a tricky one and none of the help articles I;ve researched address the problem or provide a solution. I have a VERY long list of dates in a column. The dates are entered in Australian format e.g August 31 2017 is entered on the keyboard as 31/8/17 and is then formated to display as 31...

Here is my worksheet example. I need a formula to count how many times the 'Service Level %' was greater than 79.999% for each day of the week. So for Monday, there is two data points, but, 1 would be my answer in this example. <tbody> Weekday Service Level % Calls Offered Work days Mon 81%...

<eomonth($l6,0)+1),$e6,"")))))[ quote] I am looking at the number of class hours per month across the year, and I have the table set up as such (e.g. 31/01/17, 28/02/17, 30/03/17 in the 3rd row from Q to AB) with the formula in the rows below. The first part of the formula makes the cell blank...