multi criteria match

Hello, I am trying to create a lookup of some sort that has 4 criteria (3 are text and 1 a range of numbers). The result of the lookup will be text and ideally without the need for additional concatenation columns if possible. The last criteria is a range of numbers that is unique to the company...

Hi - I've got a list of countries that correspond to certain numbers, where some numbers correspond to more than one country. I need to create a lookup on a separate tab that will list all the names that correspond to a certain number. Example where Denmark is A1 and "3" is in B1...

Hi All, I'll do my best to explain my issue. It's a similar problem to threads that I have seen resolved, but none seem to fit my problem... (I've included some context at the bottom of the post) Essentially, I need to perform a 3 (or 2) way lookup and return a result from a field on the data...

I am trying to use a sample size worth of orders to create a relationship in regards to parent-child relationships and most common occurrences of each relationship. I have tried to use several different variations of if statements along with MODE.MULT, VLOOK, TRANSPOSE, SUMPRODUCT to determine...

<tbody> A B C 1 Range No. of Deliveries Inventive 2 0-4 Zero 3 5-8 ₹ 5.00 4 9-14 ₹ 10.00 5 15-18 ₹ 15.00 6 18 Onwards ₹ 20.00 7 8 No. of Deliveries...

I am trying to do a search that is returning the incorrect result. Here is the data. Sheet1 <colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 164px"> <col style="WIDTH: 76px"></colgroup> <tbody> B C 2 Dog Cat A 3 Zebra House Car B 4 Mouse...

Good Afternoon, I'm trying to create a VBA code which will run and complete the following based in Excel 2003 & 2010. :confused: Currently 1 data table exists in one excel workbook which I'm working off. I'm trying to create a macro to run the following: 1) I need the VBA to output to a new...

Hi mrexcel forum community, I'm a newcomer what comes to VBA and would greatly appreciate your tips and help on how to solve my problem. If I've understood correctly, goal seek with input from multiple values and worksheets require VBA code. The parameters: Cell C39 in Sheet 1 (value) Cell...

I have been stuck with this problem for a while. What I am trying to do is return a reason based on an Order. How it works is that an Order is placed and may have multiple line items which would have a total number of units but when the Order is actually selected, it is done so randomly but...

I have 2 WS one with "time-entry" data (days worked) the other with "work-completed" (1 unit of work per row). I must match the 400,000 "work-completed" to 33,000 "time-entry records" ie Link/associate the "work-completed" to "time-entry" by DATE (there are multiple "work-completed" records...