Duplicate look_up values in VLOOKUP

S

SamuelT

Hi all,

I've got a VLOOKUP formula functioning in the usual way. However,
sometimes the look_up value is duplicated. When this occurs VLOOKUP
always returns the first instance of the entry. Is there a means to get
Excel to ignore entries it has already returned an entry for?

The VLOOKUP is part of a bigger formula, being:

=IF(AND('Dependency Log'!$A2=Matrix!$B3, 'Dependency
Log'!$E2=Matrix!D$2),(VLOOKUP($B3,look_up,2,FALSE)),"")

Any ideas?

TIA,

SamuelT
 
Top