I have some sheets with lots of cells using importrange function. My problem is that each sheet have different information and if my first sheet which has names changes, the names on the other sheets will change and I will lose the information corresponding to each name on the following sheets. For example: my first sheet has a column with the names and some personal information for BOB, ADAM, DAVID, CLARK. Now my second sheet brought those names in in that same order and the second sheet will then have grades for each one of them: BOB 10, ADAM 9, DAVID, 5 and CLARK 8. Now, lets say, I decide to put the first sheet in alphabetical order: ADAM, BOB, CLARK, DAVID. And that's where my problem is, because now in the second sheet ADAM has 10 points, BOB has 9, CLARK has 5 and DAVID has 8. How can I make the following cells change automatically with the first cell when using importrange?
There are too many issues here, and you probably shouldn't be using IMPORTRANGE for names if you are planning to modify them. It seems to me like you need to be using VLOOKUP with IMPORTRANGE to match relevant information, instead of just doing IMPORTRANGE.
Perfect vid
Excellent
Nice video sir!! I appreciate your work and i am waiting for next video of tables 😀😀😀
structured cell references are so cool!
Thank you!
best tricks
Man... do you ever sleep?!? Tables are a great gem. GoogleSheets needs to figure out how to compete with this.
I have some sheets with lots of cells using importrange function. My problem is that each sheet have different information and if my first sheet which has names changes, the names on the other sheets will change and I will lose the information corresponding to each name on the following sheets. For example: my first sheet has a column with the names and some personal information for BOB, ADAM, DAVID, CLARK. Now my second sheet brought those names in in that same order and the second sheet will then have grades for each one of them: BOB 10, ADAM 9, DAVID, 5 and CLARK 8. Now, lets say, I decide to put the first sheet in alphabetical order: ADAM, BOB, CLARK, DAVID. And that's where my problem is, because now in the second sheet ADAM has 10 points, BOB has 9, CLARK has 5 and DAVID has 8. How can I make the following cells change automatically with the first cell when using importrange?
There are too many issues here, and you probably shouldn't be using IMPORTRANGE for names if you are planning to modify them.
It seems to me like you need to be using VLOOKUP with IMPORTRANGE to match relevant information, instead of just doing IMPORTRANGE.
Dear Same thing is possible in google sheet ?????
Pls ans ??
No, only in Excel.