multiple critera lookup

  1. L

    Array Formula in Data Validation

    I have a difficult project i cant seem to figure out. My goal is to make an order form for people to fill out based on a bid i put out for vendors to bid on clothing. They bid on the price of the shirt or short and then they also gave the prices for a 1 color imprint, 2 color imprint.... My...
  2. A

    Display Max Value in a Textbox from a Database Column that Matches Multiple Criteria in Combo Box

    Hi !! I am having some problems with this macro I am working on. I am trying to look in a Database what is the maximum number in a column that matches 3 variables (2 in combo boxes = student name and module name, and one is a write in as you see in the example bronze). This max value should...
  3. J

    Excel Index & Match vertical and horizontal criteria for copying formula

    I have been trying to populate the following table: Final_table with order_amount from the Orders_table: I cannot crack the fact there is a second condition to be taken into account - column delivery_week. Can somebody please help me out with a formula so it can be used across the weeks in...
  4. M

    If function for multiple occurrences and one criteria

    Hi Everyone, I've been trying to get a vlookup formula to work but just realised that vlookup only looks up the first occurrence of a match. How do I make an if function which returns a value if ANY occurrence of a match meets the criteria? i.e. My raw data looks like this: Site ID Name...
  5. W

    Need help to find correct formula! Multiple criteria and range levels

    Trying to come up with a formula for a Sandbox that calculates an employee bonus's Criteria 1 - Type of Mgr - These 2 levels receive bonus based on % variance to budget * General Mgr * Asst Mgr Criteria 2 - Type of Mgr - These 2 levels receive bonus based on Store Level Sales (4 levels of Low...
  6. ncsushley

    Array formula with lookup based on multiple criteria including a date range

    I tried to find help with this question on Stack Overflow here but did not get a complete answer. I use this Google sheet to track proofreading jobs. I'm trying to modify the array formula in P1 that calculates the billable total for each job. The formula currently uses the Turnaround and...
  7. I

    Multiple Criteria: IF 2x 2-Column Matches then show corresponding value in parallel row (two sheets)

    Hi there, I'm wanting to create a formula that retrieves a unique cell value if multiple criteria are met. E.g. If 'Interface'!H8 matches item in 'ReferenceList'!ColumnT3:T245 & 'Interface'!I8 matches item in 'ReferenceList'ColumnU3:U245 then show corresponding value in...
  8. R

    Finding Data in a Table Using Multiple search Criteria

    Hi, I am looking to create a document which can find a specific bit of information based on multiple criteria. Currently i have a function which looks at a table for a Specific phone number, What i want to do is pull more a number based on a location code and the name of the number for example...
  9. C

    VBA copy and paste qualifying rows based on 2 criteria from a seperate sheet

    Hey everyone, I have a master list that I'd like to create a list of jobs from on a separate worksheet depending on a couple criteria. Here's the logic I'm looking for: IF "Job Log" (sheet name) Column S (current operation) is equal to the selected criteria on "Scheduled Capacity Graph" (sheet...
  10. S

    Best formula to use to pull in values with 2 true criteria's

    I am adding values together from 2 different sheets based on 1. date (in its own column) AND 2. if the description contains "AP" or "CD" (In another column) to populate on a summary tab. I have tried the following formulas: For my values containing AP or CD 1. =SUMPRODUCT(('GL...
  11. N

    Finding the largest item within a period using an Array Formula

    <tbody> Item no. Catagory Date Amt A T01 1/1/2017 10 A T01 1/5/2017 15 A T01 5/5/2018 20 B T01 1/1/2017 15 B T01 1/1/2017 15 B T02 1/1/2017 15 ..... </tbody> I'm trying to determine the item no. under catagory "T01", within a period from 1/1/2017 to 1/31/2017...
  12. T

    Lookup from multiple criteria, including potential partial matches

    Hi Everybody, Hoping somebody is able to help me with this formula. We have multiple departments and project codes so the actual file is much more comprehensive. I've scaled back for the sake of this example. Currently the formula below looks up the project code and the date and compares...
  13. T

    Return text value based on matching criteria including date range

    Hi Everybody, I am trying to get a formula to return a text value based on a couple inputs. Where I am running into trouble is that one of the inputs wouldn't be a match, but would be a date between a start/end date within the range it is looking at. Does anybody have any ideas on how I could...
  14. N

    Index match based on two tables

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

    Return sum of accounting dates based upon a match of corresponding cells

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

    VLOOKUP or INDEX/MATCH if date falls within range and value matches

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

    Return Values in a Column if date is between 2 columns

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

    VLOOKUP from a range matching multiple criteria

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

    Multiple Value Lookup to return an array to then be used in another formula

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top