Hello,

xxx.JPG

In the shown image, I need formula for cell E2 value.

I want to match 10055 in column A and return column B value. Row 2,4 and 5 all have 10055 number within them. But I want to match it to row 4. This is because A4 cell has 10 characters in total and it has the highest % match among others. A2 cell has 12 characters and A5 has 15 characters.

Is there a way to do it? I have shown simple example with numbers. Sometime I have table with text as well. Can any one help with this?

Thanks