Google Sheets and Lookup

Craig LaDuke
Craig LaDuke used Ask the Experts™
I have a data sheet for a program that i'm building. I would like to be able to go down the entire data sheet and look at the 1st row to see if it has a quantity. If it does i would like for it to confirm the Vendor code in the 3rd row. If this Vendor Code = ex.(Esco) then i would like for it to add the 5th row ( Part Number and Description) and 1st row (Part Quantity) to a Purchase order page. I would like for this to happen to the entire page. What i'm seeing right now is after it finds the first row with these attributes it adds this but doesn't go any further . Is there a way to accomplish what i'm trying to do?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
General Manager
I was able to use the Query function to accomplish what i was trying to. It works very well

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial