| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to reference another sheet for two variables
Here are my sheet 1 column headings:
Client #, Client Name, Location, Employee, Date On Sheet 2, I want to show every instance where an employee did billable work on a certain date, and show which client they were working on. Ex: If Kevin (column d) did billable work on date x (column e), who was it for (column b)? Sheet 1 is constantly updated and I want sheet 2 to reflect all changes. Thanks in advance to anyone who can assist with this issue. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Changing sheet reference to cell reference | Excel Worksheet Functions | |||
| Syntax for using variables in a cell formula to reference paths/fi | Excel Worksheet Functions | |||
| Vary variables in a formula via reference to another cell | Excel Discussion (Misc queries) | |||
| Trying to stack 2 variables on each other in one sheet | Excel Discussion (Misc queries) | |||
![I M Desperate!!![_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
