vlookup help

[Caro]

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 ?

[NBVC]

=VLOOKUP(LEFT(C5,4),'Other Sheet'!A:B,2,FALSE)

where Other Sheet is the name of the sheet you are looking for 1106 in, and it assumes you are looking in column A and extracting result from column B.

If you are getting #N/A and you know there should be a match, then try:

=VLOOKUP(--LEFT(C5,4),'Other Sheet'!A:B,2,FALSE)

this coercest the 1106 it extracted to a real number that might be the way your data in the other sheet is formatted.

[Caro]

Thanks