Lookup a serial number but overlook 0's in cell content when finding a match.

Hi guys,

I am attaching an excel file with instructions for your convenience.

Thanks in advance.

Hi hello,

I took a look at your book - I'm still just a little confused, but it sounds like what you want is fairly simply and can be achieved by snagging the value from the cell - i.e. something along the lines of

Please Login or Register  to view this content.

.

Hi,

Oh no, no. I think you misunderstood. I am trying to do a lookup or a match that is able to find 00000000211101B000 in column A of
sheet 2 by looking up 00211101B0 this value in column A of Sheet 1and thus bringing back the corresponding value of 00000000211101B000
from column B of sheet 2, into column B of sheet1.

The following formula does the trick thanks to JBeaucaire post
=INDEX(Sheet2!B:B, MATCH("*"&A2&"*", Sheet2!A:A, 0))

Hello Hello23, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.