CODEWITHSUNDEEP
google-sheetsformula
CYL
CYL

Reputation: 49

Pull certain information from sheets into a main sheet

Is there one formula to pull information from several sheets into a main one. Example getting Daisy Trucking Inc's information from A-N from sheet 1-8 onto there main sheet. enter image description here

enter image description hereenter image description here

enter image description here enter image description hereenter image description hereenter image description here

Upvotes: 1

Views: 33

Answers (1)

player0
player0

Reputation: 1

try:

=QUERY({Sheet1!A:N; Sheet2!A:N; Sheet3!A:N; Sheet4!A:N; 
        Sheet5!A:N; Sheet6!A:N; Sheet7!A:N; Sheet8!A:N}; 
 "where Col2 = 'Daisy Trucking Inc'"; 0)

Upvotes: 1

Related Questions