In column A (A1-A128) MD names are listed and in columns C-CB lists all the facilities they could potentially work at in a given snap shot of time. In each of the cells there can either be a blank or a 1. MDs can work at 1 or two facilities in a given day. Column B totals up columns C-CB.
In cells A130-A257 is a copy of the same information shown above in A1-CB128.
This information is used for an allocation of expenses based on MD days. If an MD worked at two facilities we want to count each day as 50%. It's not likely that the MDs will work at more than two facilities. Again column B represents the totals of all days worked across facilities.
I am trying to create a vlookup with a statement that says vlookup($a130, and if C130>1, then take 50% of each cell that represents a 1, other wise grab each cell.
I may have complicated this more than necessary and maybe a vlookup isn't the best method but we may hire/term some folks along the way.
A B C D E
ROW1: MD NAME TOTAL DAYS FACILITY A FACILITY B FACILITY C
ROW 2 SMITH 2 1 1
In cells A130-A257 is a copy of the same information shown above in A1-CB128.
This information is used for an allocation of expenses based on MD days. If an MD worked at two facilities we want to count each day as 50%. It's not likely that the MDs will work at more than two facilities. Again column B represents the totals of all days worked across facilities.
I am trying to create a vlookup with a statement that says vlookup($a130, and if C130>1, then take 50% of each cell that represents a 1, other wise grab each cell.
I may have complicated this more than necessary and maybe a vlookup isn't the best method but we may hire/term some folks along the way.
A B C D E
ROW1: MD NAME TOTAL DAYS FACILITY A FACILITY B FACILITY C
ROW 2 SMITH 2 1 1
