Numeric calculation

[Guest]

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.

 

[Ardus Petus]

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

(I've not tried it myself!)

HTH

 

[Guest]

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?

 

[Bob Phillips]

Add a heading to the number column of say NUM

In H1 add NUM
H2, add 1

Goto data>Filter>Advanced Filter and check the copy to another location
button, add H1:H2 in the Criteria range, and add say M1 to the Copy To
range.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Don't know if I'm doing something wrong but it's still not pulling through
like it should. Do you have a mailing adress so that I can send you the
workbook? Please? I really appreciate the help.

 

[Bob Phillips]

Yeah in the post heading, but note my signature.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Thanks. Sent it through to your mail this morning.

 

[Bob Phillips]

I have responded.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)