finding or matching data

Originally Posted by langdon37

What I would like to do is find a function which will match the numbers and letter in column B with the corresponding numbers in column A and then place the result in column C. eg

A B C
9111111 1234567H 9111111B
6789109 4567888
1234567 9111111B 1234567H

James

Are you looking to Swap "B" to "H" and vice versa from the end?

If that's so, then.. you can do the below

HTML Code: 

try this out!

No, not looking to swap the letters just merely for the series of numbers with the letter on the end to find the matching number in column A and input the match in cell C.

have you tried what i posted? it gives the same results as your example!

i did try it however to no avail.

i'm suprised unles your data has some spaces or something or not in the format you posted
see attached formula in c and dragged down

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...