New formula question - same sheet:
I have a file with several tabs. On my "Dashboard" tab, I have a listing of assets with a unique identifier in column A. In column F, I want to put a formula that will go to the "Hour Meter Reading" tab, look at the array (where there are multiple listings of each asset number for each time the meter was checked on the part). I want it to look in the array (column A is the asset ID, and column F is the Counter reading), and return the average of service hours since the last service, which is listed on the "Plans" tab under the column header "Changed On" (where column A has the asset number on this tab too).
Is that possible?
I have a file with several tabs. On my "Dashboard" tab, I have a listing of assets with a unique identifier in column A. In column F, I want to put a formula that will go to the "Hour Meter Reading" tab, look at the array (where there are multiple listings of each asset number for each time the meter was checked on the part). I want it to look in the array (column A is the asset ID, and column F is the Counter reading), and return the average of service hours since the last service, which is listed on the "Plans" tab under the column header "Changed On" (where column A has the asset number on this tab too).
Is that possible?