Helping a coworker- How to return a row with three criteria in an existing sheet?
Hey all , I KNOW there's an answer staring me in the face. I played around with PQ but didn't see what I liked.
My coworker has data that looks like this
In a new workbook, she wants to take this above data and return the number in C1 (and D1, and E1, etc.) in column A. But not just pasting vertically, returning it for every line of item#s. So Order A, Order A, Order A, etc.
She also wants the item# returned in column B of the new book. Short of copying and pasting, I don't know a good way to do that.
Finally, once she has those we can do an old fashioned lookup to get the qty to return in Column C, we're good there.
Any thoughts?
And please don't just say "PQ" and leave. If your answer is PQ, please give detailed instructions and advice.
Editing to add output required:
[link] [comments]
Want to read more?
Check out the full article on the original site