importrange

These are two example sheets of what I am trying to do: Reference: Reference Sheet Summary: Summary Sheet I am trying to pull information from the Reference sheet into the Summary sheet. I want to pull based on the zip code I enter into the Summary sheet, cell B2, from the row matching that...

I have two workbooks, pricing and inventory, I need to setup for a co-worker. Inventory Workbook is open to everyone on the team to reference inventory items. Pricing Workbook is visible only to the managers for setting up pricing, discounts, final-pricing, etc...for the existing inventory in...

1) Why isn't my 'importrange' working on Google sheet? The sheet does not update itself automatically. Sometimes it works, sometimes it doesn't. What are the possibilities of fault? 2) Is it possible for the importrange content to change when it is being transferred to another sheet? (Eg. Sheet...

1) Why isn't my 'importrange' working on Google sheet? The sheet does not update itself automatically. Sometimes it works, sometimes it doesn't. What are the possibilities of fault? 2) Is it possible for the importrange content to change when it is being transferred to another sheet? (Eg. Sheet...

I'm using =IMPORTRANGE("URL", "SHEET!A1:E35") to try to condense multiple worksheets into one workbook. I want to update the one book, but have the info update where appropriate on the proper forms in the folders they're supposed to be in. Currently, when it imports, the formatting and...