=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.
Bookmarks