Compare two cells if contain same number

Hi all.
I have the A2 cell with this string: IB 1234. It can be IB1234 or ib 1234, BR 1234, or whatever combination, etc..
I want to check if the A2 cell contains the samen number, and only number, as the cell A3, an return a Yes/NO in A4.
Example:
A2 B2 C2
IB1234 IB 1234 YES (it contains same number)
BR 1234. BR 1234. YES (it contains same number)
ib1234. IB 1234. YES (it contains same number)

Spanish formula if possible. I attach a workbook for that. Thanks

Hi -

Try =IF(RIGHT(A2,4)=RIGHT(B2,4),"YES","NO") then copy down.

Can you send me an example in a sheet? In spanish language the formula is diferent and gives me an error. Trying to translate and same.
Thanks

Sure. Will it always have the numbers just at the end? If so the RIGHT function looks at the value at the end and goes back x spaces (4 in your case).

=IF(RIGHT(A2,4)=RIGHT(B2,4),"YES","NO")

It works, thanks!
But now I see the problem. The number no check with B cells can be in any A cell, A range... any way for this?.
C2 is the YES NO, comparing B2 with all A range.
sorry...

I just put the formula in D, meant to put it in C ---- sorry.

So B2 will always be the same and you want to compare B2 with anything in Column A?

Exactly, yes. B2 will be the number to check, and A will be the range to search. C2 will be the result: YES if the number in B2 is in A range and NO if it's no.
thanks

Just put a $ in front of the B and the 2 in the formula then. Leave the first part of the formula as is.

=IF(RIGHT(A2,4)=RIGHT($B$2,4),"YES","NO")

So when you copy the formula down into other cells, A2 becomes A3 and A4, etc. But the B2 will always stay B2

But this does not check the entry A range, only A2.
Thanks for your help.

See my updated file to explain.

The formula in C2 looks at A2 and B2.
When you copy the formula down to C3, it will look at A3 and B2.
When you copy the formula down to C4, it will look at A4 and B2, etc

Sorry I think I don't undertand you.
I send you another wbook with explanation.
Thanks again for your help.

OK - I see what you're trying to do now. Unfortunately, don't think there is an easy formula to do that.