next occurence
 

i am currently using:
=MATCH(FIXED(B11,0,TRUE),LEFT('[Insulspan Schedule
CURRENT.xls]SCHEDULE'!$F$1:$F$400,4),0)

to find the row number in which column B value is located in another
workbook. this works great. the only thing that i need it to do is find the
next occurence if there is a duplicated value in column B. right now if there
is a duplicated value it returns the fisrt instance for all.
this function is in column A looking at the value in column B.

--
Thank You in advance, Zab