Vlookup with Duplicate values

Hi Everyone,

i want to have a vlookup formula where i have two data sets where one data set has name written once and and 2nd has duplicate names. SO i want to do a vlookup where when a vlookup is done on a duplicate data set the result should not be duplicated to the other duplicated values for example

Data Set 1

Apple 50

Kiwi 20

Data Set 2

Apple 50

Apple 0

Kiwi 20

Kiwi 0

Kiwi 0

Result is in Data set 2

Thanks

Attach a small representative sample workbook.

Make sure there is just enough data to demonstrate your need.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Attachment not working

If you followed the steps outlined in post #2, you will find that the attachment function is indeed working.

Here are the steps in a little more detail for you:
1) Click on "Go Advanced"
2) Scroll down then click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file then click on "Open"
5) Click "Upload"
6) Click "Close this window"

This is it

In B2 of "Data set 2"

=IFERROR(IF(COUNTIF($A$1:A1,$A2)=0,VLOOKUP($A2,'Data set 1'!$A$2:$B$10,2,0),0),"")

copy down

Yup it worked thanksss

Maybe use PivotTable

Hi, to all!

You can use, This formula:
['Data Set 2'!B2] : =IF(COUNTIF(A$2:A2,A2)=1,VLOOKUP(A2,'Data set 1'!$A$2:$B$3,2,),)

If you have more than one value in Data Set 1, and you want one by one results, you can use this formula:
['Data Set 2'!B2] : =IFERROR(INDEX('Data set 1'!B$2:B$3,AGGREGATE(15,6,ROW('Data set 1'!A$2:A$3)-ROW('Data set 1'!A$1)/('Data set 1'!A$2:A$3=A2),COUNTIF(A$2:A2,A2))),)

Blessings!