Try:
=INDEX('General Stock'!B2:B8,MATCH(1,'General Stock'!C2:C8))

(I've not tried it myself!)

HTH
--
AP

"Flying_Dutcman" a écrit dans le
message de news: ...
I have created an 'IF' statement which reads as follows

=IF('General Stock'!C2=1,'General Stock'!B2,"=if('General
Stock'!C3=1,'General Stock'!B3,=if('General Stock'!C4=1,'General
Stock'!B4,=if('General Stock'!C5=1,'General Stock'!B5,=if('General
Stock'!C6,'General Stock'!B6,=if('General Stock'!C7=1,'General
Stock'!B7,=if('General Stock'!C8=1,""))))))")

The problem is that if the number 1 appears in the C collum of the General
Stock sheet it pulls it through correctley but I need the formula to
continue
searching for the next correct value on the General Stock sheet. At the
moment the correct answer is found in cell C3 of the General Stock sheet
so
it is repeated twice instead of searching for the next correct answer and
pulling through that value to the first sheet.