Advanced IF function
 

Okay I need a little bit of help. I have a product order form with
sizes, colours, description ect. In that order form is a drop down cell
that says EMB or SS.
What needs to happen is that the size, colour, description copy over to
the EMB or SS worksheet when the user chooses EMB or SS from the drop
down.
The other issue I have is that the size and other information needs to
drop down a row when another item is added.
Can anyone help me?


--
wrinkle35
------------------------------------------------------------------------
wrinkle35's Profile: http://www.excelforum.com/member.php...fo&userid=2374
View this thread: http://www.excelforum.com/showthread...hreadid=471156

Try this tutorial:
http://www.officearticles.com/tutori...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"wrinkle35" wrote in
message ...

Okay I need a little bit of help. I have a product order form with
sizes, colours, description ect. In that order form is a drop down cell
that says EMB or SS.
What needs to happen is that the size, colour, description copy over to
the EMB or SS worksheet when the user chooses EMB or SS from the drop
down.
The other issue I have is that the size and other information needs to
drop down a row when another item is added.
Can anyone help me?


--
wrinkle35
------------------------------------------------------------------------
wrinkle35's Profile:
http://www.excelforum.com/member.php...fo&userid=2374
View this thread: http://www.excelforum.com/showthread...hreadid=471156

I don't really understand.

=IF(ISBLANK(product order sheet', "",VLOOKUP (B17:J17, EMB, TRUE))

So if the user chooses EMB from the Product Order sheet in cell L17,
all the info from cells B17 to J 17 will carry over to the Embroidery
Sheet?
I am not sure if I understand this formula correctly.


--
wrinkle35
------------------------------------------------------------------------
wrinkle35's Profile: http://www.excelforum.com/member.php...fo&userid=2374
View this thread: http://www.excelforum.com/showthread...hreadid=471156