<div>
<div class="content wysiwyg-content">
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?
</div>
</div>


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?

Google Sheets and Lookup

Google Workspace is a suite of cloud computing productivity and collaboration software tools and software. It includes Google’s popular web applications including Gmail, Drive, Hangouts, Calendar, and Docs. While these products are available to consumers free of charge, Google Workspace adds business-specific features such as custom email addresses at your domain and storage for documents and email.