Long Code in Sheet 1
Code Description
25-50-658-1234 Product (A) in warehouse (X)
25-51-785-4521 Product (B) in Warehouse (Y)

Short Codes in sheet 2
Code Description
50-658 Warehouse (X)
51-785 Warehouse (Y)

I want to lookup the short codes in sheet 2 to get their respective
descriptions in sheet 1.

--
tarig


"Eduardo" wrote:

Hi,
could you please post an example, thanks

"Tarig" wrote:

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