index match vlookup

Hi, There are a lot of INDEX/MATCH/VLOOKUP examples out there but I could not find the one that I need. I want the following: I have 2 tables, table 1: <colgroup><col><col><col></colgroup><tbody> Project Code Totals C 1 10 C 2 5 C 3 0 D 2 7 </tbody> and table 2 (the # and the @ are...

Dear Experts, I am using a function Index and Match to get a value from a Table that contains some Fees. In order to identify the right Fee, I am looking using three criteria. When I used two criteria it works, partially because I do not get error but the result is not correct totally , later I...

Alright. I need some help. I'm familiar with vlookups, and index,matches but I can not get this to work. I have a workbook with 2 sheets, Sheet1 and Sheet2. Sheet 1 has 11 columns. Only 3 that I care about. Name, ID Group, IDmin and IDmax. Sheet 2 has 6 columns. 3 that I care about aswell...

Hi, I am looking for something that can replace A3 and A4~A5 formulas, and be used in a table if way more columns compared to the example. What it needs to do is Look for the LINE A1 is in the table, and then return the first non blank occurance header on a3, in a4 it will give the second non...

What I would like to do is on sheet 4-6-2015 (I've got a sheet for every week of the year), look up the shift each employee is on for that week and display that in the B "Shift" column. I am using H1 as the Date reference. so for B5 on sheet "4-6-2015" I've got =INDEX(shiftstrings15!$B:$NH...