Excel question
 

Ok here's the situation. I have one sheet with line by line unique items example:

Item Lala Lala2 Lala3
304 Spec Spec Spec
305 Spec Spec Spec
308 Spec Spec Spec
etc

then I have another sheet with repeat items example:

304
304
304
304
304
304
305
305
308
308
308
308

etc.

Is there a quick way of auto filling specs to the multiple item lines based on the information I have on the single item/line sheet? I reckon it will take me a couple hours to do this manually.

$5 paypal to anyone who can explain this to me so I can get it done

Basically I need to tell it this but I don't know the language

If Z(Sheet1) = A(sheet2), copy and paste B D E and F from Sheet2 to AA AB AC AD and AE on Sheet 1

$10 paypal

That is like 10 days worth of labor in parts of Bangladesh. To bad they do not have computers though.

bump to help you!

Maybe you highlighted it and you drag it all down that's why it's repeated.

You had a nice chat with yourself :)

30 more minutes and ill be done :)

And done :)

Did you get the VLookup working, or am I off in what you were trying?

I did it manually

vlookup would be what you were looking for...remember it for next time...

I hate that program. I seem to move stuff around and run into trouble like you did. I usually look up some info on google. I wouldn't think to ask on gfy.