These are two example sheets of what I am trying to do: Reference: https://docs.google.com/spreadsheets/d/1KT7awPkrsPPvPO3WnWt_xCPdSxd0wse54BJCfo05pog/edit?gid=0#gid=0 Summary: https://docs.google.com/spreadsheets/d/1P7k1uU2V7qAAE6SkupotfUZWQANPzS6xCAPIm0Woh-c/edit?gid=177776598#gid=177776598 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 zip code in […]