![]() ![]() I know this is a lot of data to try and pull but I am at a loss for a simpler way to organize it. ![]() Sheet 2 Cells M1 through M128 are all the Call Types we utilize Sheet 2 Cells A1 through A1024 is all the information that should be pulled based on what is selected in Sheet 1 Cell C6 Sheet 1 Cells A19, A21, A23, A25, A27, and A29 are the required questions that the Call Taker should be asking (Complete formula is in A19 with ' in front of Sheet 1 Cell C6 is the dropdown of all the Call Types and pulls from Sheet 2 Cells M1 through M128 I have attached a copy of document (had to use google docs since I cant upload the excel document so lost some functionality of the document like dropdown in C6) to provide a clear picture of what we are working with. With the document open, go to File > Download. Find the document you want to export to Sheets and open it. There are 128 items in the dropdown for the IF function to read from, I know I can split it into 2 documents to make it work but was hoping that there might be someone here that can help me figure out a work around. Open Google Docs in a web browser and sign-in to your account. ![]() Open a new Google spreadsheet and click File -> Import. I am attempting to develop a QA/QI form for my 911 Center in excel and need the formula to read a dropdown cell and reference sheet 2 to pull a specific line. You can also import CSVs into Google Sheets directly from the file menu. Pull your paid search and social advertising data into one spreadsheet, and turn them into beautiful reporting dashboards you’ll be proud to show your team managers and directors. I am trying to use it to return specific information. To boost your efficiency in Google Sheets, consider using add-ons. Ok, so I have searched this site and must have checked out 20 different discussions in regard to the IF function and alternatives, however it seems that in most instances it is for financial. ![]()
0 Comments
Leave a Reply. |