writing a recursive function

Hi Rmoney,

To scan through N2:Nx, try:

=IFERROR(INDEX('Equipment List'!A2:A10,MATCH(TRUE,'Equipment List'!N2:N10,0)),"-")

This is a 2007-2010 function that will not work in 2003 or previous versions. For compatibility with older versions, use

=IF(ISNA(INDEX('Equipment List'!A2:A10,MATCH(TRUE,'Equipment List'!N2:N10,0))),"-",INDEX('Equipment List'!A2:A10,MATCH(TRUE,'Equipment List'!N2:N10,0)))