Hi, I have a column of numbers with 6 digits in Column A. In B1 I input a 3 digit number. I want to find out if the 3 digit number that I enter appears anywhere within the 6 numbers. With the example below using the Match function I would hope to get row 4 as the answer. I tried the Match function e.g. =Match("*"B1&"*",A1:a4,1) but get N/A. Is this possible?
col A........col B
122456....234
383743
923437
812231
Bookmarks