Display a blank cell if Vlookup is repeating

[sagarsangani]

Hello,


I have a table in the following format:


ABC 123

XYZ 456

ABC =vlookup


I want excel to display a blank cell after a specific vlookup value has already been displayed.


My formula right now displays #value: =IF(VLOOKUP(A5,A3:B4,2,0)=B$3:B4,"",VLOOKUP(A5,A3:B4,2,0))


What am I missing?

 

[Luke M]

This is not correct:

VLOOKUP(A5,A3:B4,2,0)=B$3:B4


A better method would be to simply count, like this:

=IF(COUNTIF(A$2:A2,A2)>1,"",VLOOKUP(A2,YourTable,2,0))

 

[sagarsangani]

Nice idea but that didn't work for me. The value does repeat.

 

[Luke M]

In your table, I was assuming the first "123" is a formula result. This formula should be the one I posted, hence why the COUNTIF reference only a single row to adjust. If this is not the case, you may need to make the formula:

=IF(COUNTIF(A$2:A5,A5)>1,"",VLOOKUP(A5,YourTable,2,0))

 

[sagarsangani]

That worked. Thanks, Luke!!