|
|
#1
08-09-2019, 02:01 PM
|
|||
|
|||
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). 
|
| Tags |
| lookup formula, search column |
|
|
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 |
Windows 10 
Office 2019
Threaded Mode