Hi,

I have a long code that contains shorter codes that I wish to look them up
with similar codes in another sheet, is there anyway that I can do this in
one step lookup rather than splitting up these long codes?

Thanks
--
tarig