e4excel i think you mis-understood the problem
the list was quite short so perhaps a longer example would have clarified it
what the op wanted to do was search using the value from say A1 in the
range b:b and if a match was found return that value but since
9111111 would not match 9111111H a wild card is used effectively
"find 9111111* in range b:b if found return that value " which in this case was 9111111H , but it may well have been 9111111D if that was in the table instead of 9111111H