hi all so i have a sheet
its called roster
say one cell contains all the data below
1106
14:35-23:41
8h36
I know how to select certain part (left,right,mid) but want to include this with a vlookup
=VLOOKUP(ROSTER!,LEFT(C5,4))
how do i correct this ?
its called roster
say one cell contains all the data below
1106
14:35-23:41
8h36
I know how to select certain part (left,right,mid) but want to include this with a vlookup
=VLOOKUP(ROSTER!,LEFT(C5,4))
how do i correct this ?