Importrange question - google sheets

YvesV

New Member
Joined
Sep 15, 2021
Messages
5
Office Version
  1. 365
Platform
  1. Windows
Hi everyone,

I think I'm just making a small mistake, but in order to save time, hopefully you can help me out.

I want to bring over information from 1 sheet (pivot table) into another sheet. This is the source sheet, I've left out column A because it contains names, so left it our for privacy reasons.
Each row has a different name, so let's say Mrs A until Mrs G.

1632728118252.png



I want to bring this over into another sheet, but next to the correct name. So that wherever I put Mrs G in that importrange and refer to column C, it would import "60". If I refer to column 4 or D, it would import "1193", etc.
I had set it up with Importrange refering to the actual cell, which worked:

=IMPORTRANGE("1SpIxYl1-Nm7q6ELo5MSkTyRO8tln9_FEFI4J4d7Z03g","Pivot Table PE - individual!C3")

Until new people started sending in forms. If they then alphabetically get inserted somewhere, everything from thereon starts refering to the wrong cells as a result of that.

I've tried setting up a new formula, the problem is that it brings over information from this sheet, but always the first row of my selected range (in this case "1390") for instance if I would select C column as import column, even though I'm referring to Mrs G and I would like "60" to be brought over intstead of "1390".

This is the formula I've tried:

=QUERY(IMPORTRANGE("1SpIxYl1-Nm7q6ELo5MSkTyRO8tln9_FEFI4J4d7Z03g","Pivot Table PE - individual!C1:C"),"SELECT * Where Col1='Mrs G'",1)

Mrs G in this example would than be the actual name of course. Or maybe I need something else altogether. Appreciate any input.

Many thanks!
Yves
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top