Cell’s value to be MATCHED with the last digit of another cell

[hsandeep]

Cell D3 generates values
F2 also generates value but is of MAXIMUM 1 digit.
I need
G3=1 IF D3’s value ENDS WITH value of F2 else 0

How to accomplish?
Thanks in advance.

Book2.xlsx
	D	E	F	G
2			E
3	42000CE			1
4	42000CC			0
5	41E			1
6	E			1
7	ABCD			0
Sheet5

 

[hsandeep]

So does column H formula have any issue?



It is becuase this part of formula RIGHT(D3)=$F$2 will return TRUE and FALSE and then "--" will convert TRUE into 1 and FALSE into 0


you can look here:

The double negative in Excel formulas

The double negative coerces TRUE or FALSE values to their numeric equivalents, 1 and 0. This is a useful technique in many advanced formulas that work with cell ranges.

exceljet.net

While in column H formula N() will convert it TRUE into 1 and so on.

Very True rather very--