vlookup to match against first instance only, remain blank for other matches

[p4nny]

Hi

I hope this makes sense. I'm trying to do a lookup which would return the match against the first instance and be blank for the remainder of the matches.

Appreciate any help

Red	returned look up value
Red	(Blank)
Red	(Blank)
Yellow	returned look up value
Black	returned look up value
Black	(Blank)

<tbody>
</tbody>

retuned look up value

<tbody>
</tbody>

retuned look up value

<tbody>
</tbody>

 

[Marcelo Branco]

You should use an array formula like
=IFERROR(INDEX(range_column,SMALL(IF(condition, ROW(range)),ROWS(...))),"")
Ctrl+Shift+Enter

A small data sample (~10 rows) would be helpful.

M.

 

[Special-K99]

Can't you simply do this?

in B1
=IF(COUNTIF(A$1:A1,A1)>1,"",VLOOKUP...)
and copy down the column

 

[Marcelo Branco]

I misunderstood your question. Disregard my post above.

M