array formula lookup

Table 1: <tbody> Date Code Price Ideal Price 01/01/2017 7 ? 0 02/02/2017 4 ? 0 03/03/2017 7 ? 80 </tbody> Table 2: <tbody> Sale Date Code Price 01/10/2017 4 $70 03/02/2017 4 $65 03/06/2017 7 $80 </tbody> I want to populate table 1 prices based on a combination of...

HI there I am tracking the daily activities of staff to see where they are spending the majority of their time and where their pain points are. I have a tab full of data that has been entered in intervals and i want to be able to count the differerent users activities across the whole time...

I was trying to write a formula that will enable me to chose a school name (from a data validation dropdown list) and have 4 years of test scores come up. I wrote the following formula which works really well except for 1 small problem. It sorts the data for a given school in ascending order...

Hello, This is my first post on Mr. Excel and thanks beforehand for any help you can give! My problem is as follows: I am working on a workbook to keep track of individual projects in a company. Each project has its own worksheet. In each worksheet I have a chart estimating labor in distinct...

Hello, I have a apparently simple issue which shows lots of resistance in spite of lots of research on array formulas and constant arrays. I have in a1 a date (let s say 12/05/13) and in b1 another date (15/05/13). In cell B3, I want an array composed of all the dates included in that range...

I am using the following array formula to count the occurrances of a unique string: {=SUM(IF(ISNUMBER(FIND("search string",Data!B:B,1)),1,0))} My worksheet contains the following sample data: ColA ColB Yes this is the search item Yes this is also the search string Yes...

I have been doing a lot of reading up on this subject and I think im getting closer to understanding what im meant to do however when I put into practice with a more complicated search argument it falls to pieces. I have a complicated workbook which a main tab with 60 odd columns and thousands...

I'm pretty good with excel, but this is tricky... I have a table of bid results for multiple projects my company has bid. Outside of the table, I need to look at a given company's performance, like the total backlog (or rank 1 bids): {=SUM(([Company]=F2)*([Rank]=1)*([Bid]))} = $691,469 Not...