In the example of data that I initially supplied the data in sheet2 did not have any values that matched sheet1. I upated the example but still need help with the formula. I don't want to get rid of the the first 3 digits.

The data in both sheets have the same formating. So that shouldn't be the problem.

I almost have it in the initial formula, except it only returns column 2 in sheet2 when the information matches the first record in the sheet2.


Thanks the input of information thus far from everyone.