PDA

View Full Version : Solved: simple problem im sure



rayoconnell
05-11-2007, 03:40 AM
hello all,

here is my problem, i am trying to auto fill spreadsheet that our clients give us. it has to be in a specific format. when they give it to us they have 3 headings eg.

H I J
Vessel Ferm Waste_SYS
Y
Y Y
Y
y Y


the above goes on for about 200 lines.
what i need to do is,
if there is a Y in the H column then enter "vessel" in the C column on the same row.
likewise for I, if there is a y enter "ferm" in the C column and again for "J":mkay confused please help

Bob Phillips
05-11-2007, 03:51 AM
=IF(H2="Y","vessel",IF(OR(I2="Y",J2="Y"),"ferm",""))

rayoconnell
05-11-2007, 04:05 AM
that kinda works
however it will only work on row 2, there is surely a way to implement a formulae to copy and paste to 500 lines in the c column that will check down trough each of the H, I and J columns.

Bob Phillips
05-11-2007, 04:11 AM
Just drag-copy the formula down.

rayoconnell
05-11-2007, 04:11 AM
that kinda works
however it will only work on row 2, there is surely a way to implement a formulae to copy and paste to 500 lines in the c column that will check down trough each of the H, I and J columns.

rayoconnell
05-11-2007, 04:12 AM
but it still only refers to row 2 how can i change it on each row

rayoconnell
05-11-2007, 04:14 AM
sorry bud you were right of course,
thanks a million,
i love this site