multiple critera lookup

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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