multiple critera lookup

I am using an individual number (Master NSN) on my main sheet to return Team name based on two other tables. I match the tims-nsnnumber from the first table (Achieved10Credits) with the Master NSN. The main issue lies with adding in a second criteria based on another lookup. I aim to use the...

Hi, I am looking for a formula route to return a count of accounting dates based upon a match of corresponding cells. I’ve had a look through the forum but can’t see a similar answer, although I have seen a few with more complex analysis. The Reference data is no more than 100 lines. Sadly...

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

Hello, This is my first time posting here and I've searched everywhere to find the resolution to my issue but was unable to find a solution. I am trying to get B1 to bring back the value in Column F based on multiple criteria: (A1 is >= D:D and A1 <= E:E and C = "Collared") If we do this...

Hello. I've been struggling with this all morning. I had the following sheet that worked fine. The user enters SUBJECT STATE, in this case KY for Kentucky. Below there is a table called, "FullCompDataSet", with 3 columns. I need to do 2 things from this data (output shown below in red): A...

Hi Guys, I have a scenario where I know the combination of hard drives that is most economical to use for a given system design. I know the Total Storage, the Quantity of HDD's used, and the capacity of each HDD used to create the total storage. In addition to this I have a data rate for...