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]

vlookup will always return the first occurrence as designed (correctly so, if l may add).

 

[handri]

thank mate,

is it anyway to resolve it.

thanks

 

[Aladin Akyurek]

In B3 of Sheet2 control+shift+enter, copy across, and down:

=IFERROR(INDEX(Sheet1!$C$2:$C$20,SMALL(IF(Sheet1!$B$2:$B$20=$A3,ROW(Sheet1!$C$2:$C$20)-ROW(Sheet1!$C$2)+1),COLUMNS($B3:B3))),"")

 

[handri]

Already copy to B3. When i add another duplicate item (same name). B3 is not updating the entry.

e.g As i needed

sheet 1

DATA ENTRY

1.APPLE 1
2.ORANGE 2
3.APPLE 1
4.CARROT 3
5.APPLE 2
6.APPLE 1
7.APPLE 1
8.ORANGE 2

Sheet 2

DATA BANK FROM ENTRY SHEET 1

APPLE =6
ORANGE =4
CARROT =3

this module that i meant if any confusion

 

[Aladin Akyurek]

I assume 1. etc. are not part of your data in Sheet1.

In B2 of Sheet2 enter and copy down:

=SUMIFS(Sheet1!B:B,Sheet1!A:A,$A1)

where $A1 = APPLE, $A2 = ORANGE, etc.

 

[handri]

Below is my workbook with 2 sheet describes

https://ibb.co/cZ3FOR

https://ibb.co/bDM8cm

thank you

 

[Aladin Akyurek]

Below is my workbook with 2 sheet describes

https://ibb.co/cZ3FOR

https://ibb.co/bDM8cm

thank you

Post #4 and post #6 are two answers for you to evaluate.

 

[handri]

noted

 

[handri]

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")

I assume 1. etc. are not part of your data in Sheet1.

In B2 of Sheet2 enter and copy down:

=SUMIFS(Sheet1!B:B,Sheet1!A:A,$A1)

where $A1 = APPLE, $A2 = ORANGE, etc.