Vlookup duplicate with same value

[QUIJAN]

Hello,

I am trying to use the vlook up for the duplicate value.
I just want the first value in Column A to have the result for the column B.

Please see the result when I use the vlookup (SAMPLE1) and the result I want to achieve (SAMPLE2)

Thank you

 

[hrayani]

Book4
	A	B	C	D	E
1	ITEM	FEE		ITEM	FEE
2	ABC1234	$ 5		ABC1234	$ 5
3	ABC1234	$ 5		ABC1234
4	ABC1234	$ 5		ABC1234
5	ABC1235	$ 10		ABC1235	$ 10
6	ABC1235	$ 10		ABC1235
7	ABC1235	$ 10		ABC1235
8	ABC1235	$ 10		ABC1235
9	ABC1236	$ 2		ABC1236	$ 2
10	ABC1236	$ 2		ABC1236
11	ABC1236	$ 2		ABC1236
12	ABC1237	$ 4		ABC1237	$ 4
13	ABC1238	$ 8		ABC1238	$ 8
Sheet1

Cell Formulas
Range	Formula
E2:E13	E2	=IF(D2=D1,"",VLOOKUP(D2,$A$2:$B$13,2,FALSE))

 

[QUIJAN]

Book4
	A	B	C	D	E
1	ITEM	FEE		ITEM	FEE
2	ABC1234	$ 5		ABC1234	$ 5
3	ABC1234	$ 5		ABC1234
4	ABC1234	$ 5		ABC1234
5	ABC1235	$ 10		ABC1235	$ 10
6	ABC1235	$ 10		ABC1235
7	ABC1235	$ 10		ABC1235
8	ABC1235	$ 10		ABC1235
9	ABC1236	$ 2		ABC1236	$ 2
10	ABC1236	$ 2		ABC1236
11	ABC1236	$ 2		ABC1236
12	ABC1237	$ 4		ABC1237	$ 4
13	ABC1238	$ 8		ABC1238	$ 8
Sheet1

Cell Formulas
Range	Formula
E2:E13	E2	=IF(D2=D1,"",VLOOKUP(D2,$A$2:$B$13,2,FALSE))

Hello

Thank you for that.
Data for my vlookup is in the other tab.
Is it okay to use this?

I mean, the data for column B is in the another tab.

 

[hrayani]

Yes you just need to change the lookup location

For example DATA sheet

Book5
	A	B
1	ITEM	FEE
2	ABC1234	$ 5
3	ABC1234	$ 5
4	ABC1234	$ 5
5	ABC1235	$ 10
6	ABC1235	$ 10
7	ABC1235	$ 10
8	ABC1235	$ 10
9	ABC1236	$ 2
10	ABC1236	$ 2
11	ABC1236	$ 2
12	ABC1237	$ 4
13	ABC1238	$ 8
DATA

Result Sheet

Book5
	A	B
1	ITEM	FEE
2	ABC1234	$ 5
3	ABC1234
4	ABC1234
5	ABC1235	$ 10
6	ABC1235
7	ABC1235
8	ABC1235
9	ABC1236	$ 2
10	ABC1236
11	ABC1236
12	ABC1237	$ 4
13	ABC1238	$ 8
RESULT

Cell Formulas
Range	Formula
B2:B13	B2	=IF(A2=A1,"",VLOOKUP(A2,DATA!$A$2:$B$13,2,FALSE))