VLOOKUP Question

[dlsdioquino]

Hello all!

I have a question regarding VLOOKUp.

I have a list of IDs and Values. In a set of data I need to get the IDs with only ONE occurrence.
Here is the Sample
Look up table

ID           VALUE
1             a
2             b
2             c
4             d
4             e
5             f

VLookUP Expected Result

[B]ID           VALUE[/B]
1             a
2             
3
4
5             f

Thank you so much!

 

[mole999]

I cant see the logic of not getting 2 to 4 returned. VLookup will return the first value from a sorted list against the reference value

 

[dlsdioquino]

I cant see the logic of not getting 2 to 4 returned. VLookup will return the first value from a sorted list against the reference value

It's because 2 occured twice. I just need the data that occurs once

 

[mole999]

got it now

 

[kvsrinivasamurthy]

Data in Sheet1
In B2 of Sheet2 then drag down

=IF(COUNTIF(Sheet1!$A$2:$A$6,A2)=1,VLOOKUP(A2,Sheet1!$A$2:$B$6,2,0),"")

 

[dlsdioquino]

Data in Sheet1
In B2 of Sheet2 then drag down

=IF(COUNTIF(Sheet1!$A$2:$A$6,A2)=1,VLOOKUP(A2,Sheet1!$A$2:$B$6,2,0),"")

Thank you so much it works like a charm!