VLOOKUP Duplicates First Item

[ScyberMhaster]

Good day!

I badly need help with my workbook. I put sample values on my first sheet (Obj.Data), and I want to show it on my transmittal sheet (Data.Output). I used these functions:

Pivot Table the Date, so I can remove duplicates or same dates. Then, I used Data Validation, and make the Pivot Table as source (date), to make drop-down list on my Data.Output. So I can choose the date which I wanted to display for my transmittal sheet. Then, I used VLOOKUP and IFERROR, to extract data from Obj.Data sheet. However, I have found error. The first row, is correct, but the second row only duplicates the first row.

B4 = Data Validation (Source = Pivot Table, Date)

ROW 1
=IFERROR(VLOOKUP(B4,Obj.Monitor!A:G,3,FALSE),"")
OUTPUT: Sample Name 1

ROW2
=IFERROR(VLOOKUP(B4,Obj.Monitor!A:G,3,FALSE),"")
OUTPUT: Sample Name 1
(Which should be Sample Name 2)

Please download the Excel File here.
https://ufile.io/e63fu

 

[Marcelo Branco]

Thank you sir! It worked!!!

You're welcome. Thanks for the feedback.

M.