vlookup help

Caro

New member
Joined
Mar 1, 2014
Messages
12
Reaction score
0
Points
0
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

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
=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.
 
Top