PDA

View Full Version : Comparing values between cells



odc156
2012-06-12, 03:21 AM
Does a function exist in excel to compare values between cells in the following way?

12345 56
23456
34567

Look into first column to find any number that has the last two digits that match the number in the second column. In this case 56.

CheshireCat
2012-06-12, 06:12 AM
How about this:



=MATCH(TEXT(B1,0),INDEX(RIGHT(A1:A3,2),0,1),0)


Cheers,