finding or matching data

SCRUB THAT, my eyesight is failing me, gone number blind. your code worked perfectly.

thanks

Langdon,

I think my code also was giving the same output as martindwilson
Did u try that?

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

Dear Martin,

Perhaps you are right, Im aware of the Wildcard character usage,however honestly i was not able to understand the query honestly and based my code on the solution in Col C...

But thanks anyways...