Remove duplicate value when vlooked up from other sheet

[Debabrata]

Hello,

Refer the uploaded file wherein I tried to remove the duplicate threads while vlooked up from other spreadsheet.
Refer column "F" wherein I want to get the value which should not repeat again in the next cells.
Refer column about the remarks to show an example


Debabrata

 

[Somendra Misra]

Hi,

See your file.

Regards,

 

[xlstime]

Firstly welcome to Chandoo.

Please use below formula

F2 = =IF(COUNTIF($D$2:D2,D2)=1,VLOOKUP(D2,'to be vlookup from this sheet'!$A$2:$B$161,2,0),0)

and drag

Hello,

Refer the uploaded file wherein I tried to remove the duplicate threads while vlooked up from other spreadsheet.
Refer column "F" wherein I want to get the value which should not repeat again in the next cells.
Refer column about the remarks to show an example


Debabrata

 

[Debabrata]

Hi Somendra and xlstime,

Thank you very much for helping me out of the situation.
I was breaking my head from 2hours to solve this but finally..........you made my life easier.

It's a great platform to exchange ideas.

Thanks a lot again.

Regards,

 

[Naresh Yadav]

Hi,

you can also try this one

=(MATCH(D2,$D$2:$D$701,0)=ROW(A1))*VLOOKUP(D2,'to be vlookup from this sheet'!$A$1:$B$161,2,0)

 

[Debabrata]

Hi,

you can also try this one

=(MATCH(D2,$D$2:$D$701,0)=ROW(A1))*VLOOKUP(D2,'to be vlookup from this sheet'!$A$1:$B$161,2,0)

Hi Naresh,

It is working perfectly..... Thank you very much.