Hey all, stuck on this one and its infuriating!!
I have a range (print sheet a17:a31) that can have hundreds of possible part numbers in it. On another worksheet I have all possible items (inventory sheet a2:a672) I want to have excel give me the quantity entered on the original sheet (print sheet c17:c31) spit out on column G in my master sheet.
To give you an idea of what I'd like to express, itd be like: if inventory sheet's a2 equals anything from print sheet's a17:a31, spit out the corresponding print sheet column C into the inventory sheet's column G.
I know it's kind of confusing. It is to me too!! Thanks for the help!
I have a range (print sheet a17:a31) that can have hundreds of possible part numbers in it. On another worksheet I have all possible items (inventory sheet a2:a672) I want to have excel give me the quantity entered on the original sheet (print sheet c17:c31) spit out on column G in my master sheet.
To give you an idea of what I'd like to express, itd be like: if inventory sheet's a2 equals anything from print sheet's a17:a31, spit out the corresponding print sheet column C into the inventory sheet's column G.
I know it's kind of confusing. It is to me too!! Thanks for the help!