Vlookup in 2 sheet in same workbook

[handri]

hi

I have 2 sheet in my workbook. 1st sheet is where is my item will be enter(down direction). 2nd sheet (Singe item) is my data bank which collected what are being entered in 1st sheet. Below is my vlookup formula

=VLOOKUP(A3,Sheet1!$B$2:C20,2,FALSE)

Problem is when duplicate item(common) being entered in sheet 1, the data bank will not capture in 2nd sheet.

In the meantime, thank you so much for your attention and participation

 

[Aladin Akyurek]

OK after stumble this i finally got it. Because i am a beginner. So some formula need to take time to understand it.
below is my code. And now i understand how its work.

=SUMIFS(ENTRY!B1:B30,ENTRY!A1:A30,"DELL")

That's great. You made my day.