{=TRANSPOSE(INDIRECT(ADDRESS(MIN(IF((Sheet1!A1:A10 00=Sheet2!A1)*(ROW(Sheet1!A1:A1000)=MATCH(Sheet2! A2,Sheet1!B:B,0)),ROW(Sheet1!A1:A1000),"")),3,,,"S heet1")&":"&ADDRESS(MIN(IF((Sheet1!A1:A1000=Sheet2 !A1)*(ROW(Sheet1!A1:A1000)=MATCH(Sheet2!A2,Sheet1 !B:B,0)),ROW(Sheet1!A1:A1000),"")),6)))}



I am trying to input this function has an array, I is not working, what am I
doing wrong.
--
ca1358