Doesn't work yet. I need the following info to go to different sheets
according to the number in the type of item colum.
B C
ITEM DESCRIPTION TYPE OF ITEM
Pen, Ball Point, Black Ink 1
Pen, Ball Point, Red Ink 1
Pen, Ball Point, Blue Ink 3
Paper, A4, 80 gsm, ream 4
Paper, A4, 80 gsm 5
Paper, A3, 90 gsm 1
pen 1

It needs to look something like this:

B C
Pen, Ball Point, Black Ink 1
Pen, Ball Point, Red Ink 1
Paper, A3, 90 gsm 1
pen 1

If you can please help. It's very urgent for a stocktake at work?

"Ardus Petus" wrote:

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.