|
|
#14
02-05-2016, 09:30 PM
|
|||
|
|||
Take a look at the formula in sheet BC, cell A4. You will note that the last argument of the INDEX-function has a "1" meaning that it takes a value from the first column in d (sheet Master). Now look at the formula in BC!B4 and note that it has "4" as the last argument of the INDEX-function meaning that it takes a value from column 4 in d, that is the column with Hours.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Setting autofilter criteria using columns and cells relative to the active cell in another sheet
|
SarahL | Excel Programming | 7 | 06-11-2015 10:26 AM |
| Populating Data in New TABs? | Sueade | Excel | 2 | 06-02-2015 09:12 PM |
|
Delete blank rows between the two rows that contain data
|
beginner | Excel Programming | 5 | 12-26-2014 12:29 AM |
|
Is it possible to take a row on sheet 1 and transfer the info to sheet 2 by rows on conditions.
|
rogcar75 | Excel | 3 | 08-28-2014 05:21 PM |
| Fix data output position relative to page | Al See | Mail Merge | 1 | 01-16-2014 04:13 PM |
Windows 10 
Office 2013
Threaded Mode