lookup criteria

I have a worksheet that utilizes several functions to get data depending on other information. One “Category” inputs Mobile Phone based on the amount of a given month’s expense. This amount can vary as you can see by the attached Xl2bb. Is there some way whenever the monthly Mobile expense...

Hello, I'm trying to figure out if this is possible. I want to use a vlookup (or any formula) to return the lowest value of 5 specific values. We have 7 INDIVIDUAL MODEL NUMBERS. Then we have PACKAGE MODEL NUMBERS that include 5 of the INDIVIDUAL MODEL NUMBERS. In (Column D, Rows 2,3,4) I...

<tbody> Date Round Home Team Home Score Away Score Away Team 13/09/2013 1 TEAM A 1 1 TEAM B 12/09/2013 1 TEAM C 2 1 TEAM D 20/09/2013 2 TEAM C 1 1 TEAM A 27/09/2013 3 TEAM A 2 1 TEAM D 05/10/2013 4 TEAM C 2 2 TEAM B 06/10/2013 4 TEAM D 1 4 TEAM A 15/10/2013 5 TEAM A 1 1 TEAM E...

Hi, I'm new to this forum, and equally new to using macros in Excel 2007. I basically need to merge three tables into one. The first two tables contains rates based on an issue age, and a fixed period of time. The only difference between them is the first table is for a "Band" class 1, the...

Search Table <tbody> AA XX 23 AA XY 34 AA XZ 42 BB XX 12 BB XY 13 BB XZ 25 CC XX 10 CC XY 8 </tbody> Present Table <tbody> Criteria 1 Criteria 2 Result BB XX Formula </tbody> I need to build up a formula which searching criteria 1&2 on the 'search table" bring the third...

Greetings Everybody :) I have a workbook in wich I consolidate 65,535 rows of data from 6 other workbooks using compound lookup. I lookup (using INDEX & MATCH) based on a double criteria. That's not the issue. The issue is that I need to grab not only the values of the matching cells, but also...