match multiple criteria

Hi, I have a dataset with four columns (A:D) and a cell (E5) containing comma-separated values. I need to extract all matching values from column B that meet specific criteria while preserving the order presented in cell E5. A B C D 2 01-0012 3 01-0011 This 4 01-0013 1 01-00102...

I have this input table tracking time spent on various activities over a year (first table below). I want to show it in an output table with rows as days and time slots as columns (see 2nd table below) to get an overview of how time was spent. I can use IndexMatchMatch in I2 for the Aug 3 type...

Hello all, I'll get right to the point... I have 2 sheets Sheet1 <tbody> A B C 1 Bill Murry 05/14/2007 WI 2 Bill Murry 02/20/2008 TX 3 Bill Murry 11/12/2008 NY </tbody> On my second sheet I have <tbody> A B C D 1 Bill Murry 03/02/2007 08/04/2007 **Formula** = WI 2 Bill Murry...

Hi all. I need help in making an Excel macro that searches a word document for words from a word list and then copies the matching terms back into the spreadsheet

Hello, I need assistance with matching on two columns/fields across two different worksheets and returning a value in a cell from one worksheet to another if there is an exact match. Specifically, I am beginning in column "W" in the sheet entitled "Personnel". I need to match on the CAN and...

Hi All, I’d like to post the following question. In one sheet I’d like the user to select from 3 dropdown lists certain predefined values. On the second sheet there is a long list of unique cells (one column, that can't be split into usefull columns with text to columns or something). I...

Yikes! It sounds horrible but here goes... Using Excel 2010: Worksheet 1 - Need to find C (Status) from Worksheet 2 <TBODY> A B C 1 Business Name Address Status 2 Joe's Bar & Grill 1111 Main St ? 3 Ace Shop 4186 Power Inn Rd ? 4 Thomas Train 1717 Rail way ...

Hi. Can you help me solve this puzzle? Hope so. I've begun by showing the setup I have, but if you want to read the task and problem first, they're stated below. Tables have been stripped down to the essential columns; and cell references and sheet names have been simplified. SCENARIO / SETUP...