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.
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
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.
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