#1
|
|||
|
|||
Compare two columns from a table and get value from third column
I have a table of data with employee schedules for different events.
I am trying to represent the data in a weekly view separately to show for each day of the week which employees are scheduled for different events. In the attached spreadsheet, in cell H6, I want to query [Shedule] table for events on the July 29 (H4) for employee Ron (F6). |
#2
|
||||
|
||||
Array-enter (=commit the formula to the sheet with Ctrl+Shift+Enter, not just Enter) this formula in cell G5, then copy down and across:
Code:
=IFERROR(INDEX(Schedule[Event],MATCH(G$4&"|"&$F5,Schedule[Date]&"|"&Schedule[Employee],0)),"") Another way, not needing array-entering, is to enter the following in cell G5: Code:
=IFERROR(INDEX(Schedule[Event],INDEX(MATCH(G$4&"|"&$F5,Schedule[Date]&"|"&Schedule[Employee],0),,)),"") (Yes, you can do this in one step by selecting G5:M8, put the formula in the formula bar, hold Ctrl and press Enter.) |
#3
|
|||
|
|||
@p45Cal - Exactly what I was looking for. Thank you very much.
|
Tags |
lookup formula, search column |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Merge table cells across columns but skip if column don't exist | jhearing | Word Tables | 4 | 05-31-2016 06:20 AM |
Column text flow with table across the columns | ravenns | Word | 3 | 07-11-2013 11:29 PM |
Compare columns + calculate difference | Inatic | Excel | 1 | 01-27-2013 08:00 AM |
Long, 3 Column Table - Can I make Fit Into Page Columns? | Rigwald | Word Tables | 9 | 08-07-2012 08:14 PM |
How to compare 2 columns with other two columns in EXECL 2007? | Learner7 | Excel | 5 | 06-12-2010 09:54 AM |