multiple critera lookup

  1. L

    Excel Formula Multiple if then

    I would greatly appreciate it if someone could help me. I am feeling not so smart today. LOL I need to create a formula based on several criteria. The first step is to find all of the matches in one column, then I need to take all of the items that match and tell it to look at another column...
  2. C

    Return Item with Multiple Search Criteria

    Hello- I have an excel workbook with two tabs. One data set including transactions with relevant data columns: Account Number & Amount. The second tab has a comprehensive export of data that I am trying to match with the first tab of data. The relevant data columns are included as well as a...
  3. O

    VBA Lookup from 2 different tables (in different sheets from a single workbook) to make logical conclusion and print result in cell

    Hello, I have quite a challenge here .. I am trying to lookup multiple values from 2 different tables from different sheets in a single workbook (different from the one I am applying VBA to) I wrote this code from scratch but the from so I apologize in advance for the obvious errors or...
  4. F

    lookup value with two criteria with array

    hi can anyone help me in following lookup value with multiple criteria, but i want with array plus, which is faster. array formula or vlookup? date code Rate 25-May-21 613974 0.376 24-Jun-21 613974 0.376 15-Sep-21 613974 0.376 20-Sep-21 613974 0.376 29-Oct-21 613974 0.39 21-Dec-21...
  5. Y

    Index & Match with the name of Tab

    Hello, I hope all is well. I don't know if we can use the index and match in this case. I tried, but I failed because I don't know how do I point the code to the name of the tab. I hope I could get some help on this one. Thank you in advance. Table I need to fill Date Total Hour Location...
  6. S

    Multiple criteria (date range, product code, value) vlookup and if functions or do I need index and match?

    I apologise if this has been asked before but I can't seem to find an answer. I need the end result to be a discount given based on the product code, date range and quantity. For example: Based on the order date, product code, and quantity from the below table the discount should be -15.00...
  7. DrMrsStark

    Formula to search range by two criteria or different two criteria, and if not found then search different range using same criteria(s)

    Hello Excel Wizards! - Longtime reader, first time writer. So I have a situation that I feel is completely do-able, because I've been able to successfully write one part of the formula to achieve my results, but cannot for the life of me get the entire formula right. I apologize in advance for...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

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
Back
Top