Timeline for How do I index and locate information on one google sheet file and import it to another file in one formula
Current License: CC BY-SA 4.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 5, 2019 at 23:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 5, 2019 at 23:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Dec 6, 2018 at 22:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Nov 6, 2018 at 22:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 7, 2018 at 21:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 7, 2018 at 18:43 | answer | added | user0 | timeline score: -1 | |
| Jun 13, 2018 at 20:37 | comment | added | Rubén - Volunteer Moderator -♦ | Yes it's possible. For further help, please edit your question and add a brief description of your search/research efforts. | |
| Jun 13, 2018 at 20:33 | comment | added | Anwaar Hassan | Thanks for responding. Understood the process and am familiar with the functions you mentioned. Is it possible to combine all functions into one formula. Otherwise it appears that I would have to import the data to the destination file on a blank sheet and then index/match the info. Is there anyway to avoid creating an additional sheet to import the data? | |
| Jun 13, 2018 at 13:45 | comment | added | Rubén - Volunteer Moderator -♦ | By using built-in formulas first we have to use IMPORTRANGE to import the data into the destination sheet, then we could use functions like VLOOKUP, QUERY, INDEX and MATCH among others to return a value or array of values that meet certain conditions. There are a lot of questions on this site about using this functions. If you need further help add more details in order to understand where are you stuck, otherwise the question is too broad for this site. | |
| Jun 13, 2018 at 13:40 | history | edited | Anwaar Hassan | CC BY-SA 4.0 |
edited title
|
| Jun 13, 2018 at 13:34 | comment | added | Anwaar Hassan | I used importRange but don't know how to go further. I need the formula to index and find the information on "Data" before it imports it into "Sales" | |
| Jun 13, 2018 at 1:57 | review | First posts | |||
| Jun 13, 2018 at 2:36 | |||||
| Jun 13, 2018 at 1:56 | comment | added | Rubén - Volunteer Moderator -♦ | The title of the question is very vague, please improve it. What formula you tried? If you got an error message add it textually. Also add a brief description of your search/research efforts. Ref How to Ask. | |
| Jun 13, 2018 at 1:52 | history | asked | Anwaar Hassan | CC BY-SA 4.0 |