VLookup

[Kabelo]

Hi,

I have got some sheet with duplicate numbers and I have used the Vlookup but it only displays the first values, for other values it displays #NA and I need to display those numbers for other duplicate values.

I have attached my sheet.

May you please assist.

Regards,
Kabelo

 

[JawaharPrem]

Hi,

Please try
=VLOOKUP(A:A,Sheet2!A:B,2,FALSE)

 

[Kabelo]

Hi JawaharPrem,

Thank you so much.

I am sorted now.

Regards,
Kabelo

 

[Siga]

Or you have to lock the area from the second sheet. Your data is placed only in A1:B2, so adda $ sign to lock it:
=VLOOKUP (A:A;Sheet2!A$1$:$B$2;2;FALSE)

Otherwise, you formula starts to take values from B3; B4; B5 and etc. and those cells have no value.

 

[Khalid NGO]

Hi,

Or the simple SUMIF:

=SUMIF(Sheet2!$A$1:$A$2,A1,Sheet2!$B$1:$B$2)

Regards,

 

[JawaharPrem]

Hi Khalid,

Nice i tried new formula learnt today from you.