Google Sheets - Index, Match, & Importrange - What is wrong with my formula?

[NessaJoy8]

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 zip code in the Reference sheet.

I am pulling different information into certain cells, such as, City, State, Awarded Carrier, Bid, ect. please help me with my formula!

This is the formula I have for one cell that I am trying to pull the Store into:

=INDEX(IMPORTRANGE("1KT7awPkrsPPvPO3WnWt_xCPdSxd0wse54BJCfo05pog/edit?gid=0#gid=0"), "RFP Carrier Rates!A1:A231",MATCH(B2,IMPORTRANGE("1KT7awPkrsPPvPO3WnWt_xCPdSxd0wse54BJCfo05pog/edit?gid=0#gid=0","RFP Carrier Rates!D1:D231")))

Here is what I have for pulling the rate in another cell:

=INDEX(IMPORTRANGE("1KT7awPkrsPPvPO3WnWt_xCPdSxd0wse54BJCfo05pog/edit?gid=0#gid=0", "RFP Carrier Rates!G2:G231"),MATCH(B2,IMPORTRANGE("1KT7awPkrsPPvPO3WnWt_xCPdSxd0wse54BJCfo05pog/edit?gid=0#gid=0","RFP Carrier Rates!D2:D231")))

Thank you for any help!

I've thought about trying Query but I don't believe that will work, I've also tried adding a reference for the Row part of Index. I've looked up videos and such to no avail, most people are just pulling straight information rather than what I'm doing so I haven't been able to figure out how to fix it!