Advanced IF function

W

wrinkle35

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

wrinkle35

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.
 
Top