yogi_For IDs In Column A Import Info For Associated Entities In Columns E:H While Making Manual Edits In Columns B C D I

Google Spreadsheet   Post  #2589

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Feb-09-2019

question by: ComputerCandy

https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/WlYpzJnxYeA;context-place=forum/docs
Import Data per Row/Column, Based on ID Number

Is there a way to import data a row at a time based on matching the ID number of a column? (Using formulas or queries in the second header row.)

I'm working on several collecting spreadsheets. The goal is that there will be a checklist template that people case use where they can edit some columns. But other columns will auto-populate data based on catalog numbers that match the catalog numbers of a master list. For example...

I made a simplified version of what I'm trying to do that anyone can edit...

Master Database List:

https://docs.google.com/spreadsheets/d/1qLCZOtByZFO47gtM2f7oewhgZ_RR2maXZ2_XkQ05Ks4/edit?usp=sharing

User Checklist:

https://docs.google.com/spreadsheets/d/1FsGx9YkQiMc6id5L7wguJ-xeGcJx-qHSB3fklBLgPyo/edit?usp=sharing

As you can see, some columns are fine for the user to edit information about their collection. But other more universal information should automatically import based on matching Catalog IDs. *If possible, it would be especially helpful if the user could still do normal column sorting.

Is this possible? Any help would be very appreciated. Thank you.