Thread: Populating data From one sheet to another, relative rows
View Single Post
 
Old 02-05-2016, 09:30 PM
xor xor is offline Windows 10 Office 2013
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
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.
Reply With Quote