Excel - comparing cells that return different format

I have 2 cells, A1 and B1, both using Index + Match function that refers to other worksheets.

I then use =if(A1=B1,TRUE,FALSE) for verification but it failed to return the correct logic.

Formula Evaluation shows =if(123="123",TRUE,FALSE) and I found out that B1 refers to a cell with text format.

Without changing other worksheets' cell format, how do I go about this?