Index Match w/ ISNUMBER(FIND ?

[SnKeaK]

So I have 3 columns of data.

COLUMN A & B contain data that remain the same.
COLUMN C I use for data entry to find the info i need, then I delete the data in those cells

What I need to figure out is, how can search the range in COL B and find if the last 4 digits in COL C matches, if false, show blank, if true, display the adjacent User ID to the PIN that was matched.

For Example: (Working in COL D, Row 1)

COL B, Row 6 - the value is 0005. I find it in COL C, Row 3. And Return the value in COL A, Row 6. 2046133

User ID	PIN	Tip's
7852881	0001	2.310002
3698031	0002	2.320005
2726638	0003	1.230001
25864254	0004	0.560007
2046133	0005	2.390006
16063637	0006	2.146717

 

[Phuoc]

Try this:

Book1
	A	B	C	D
1	User ID	PIN	Tip's
2	7852881	0001	2.310002	3698031
3	3698031	0002	2.320005	2046133
4	2726638	0003	1.230001	7852881
5	25864254	0004	0.560007
6	2046133	0005	2.390006	16063637
7	16063637	0006	2.146717
Sheet1

Cell Formulas
Range	Formula
D2:D7	D2	=IFERROR(INDEX($A$2:$A$7,MATCH(RIGHT(C2,4),$B$2:$B$7,0)),"")

 

[SnKeaK]

Thank you so much! Excellent work.