Import Data from Another Workbook
To be honest, I don't know the proper terminology. But, after spending about 4 hours working on this formula, I got it working. The problem I was trying to solve was that we had a spreadsheet that was being updated regularly with data, and we wanted to feed that data into a different spreadsheet. I knew that. I could simply do this with IMPORTRANGE , which can get the data for each cell, but then I would have to create a formula for each entry. I wanted a single formula that matched the student name to the data. I knew from past projects that the INDEX and MATCH combination was probably something that I wanted to use. So I started playing around with it. Student Name student ID gender grad year current grade DOB RTI reading level The particular data I wanted was the reading data. In the end, ChatGPT helped me figure out that the formula would be something like the following. = VLOOKUP ( A7 , IMPORTRANGE ( "URL" , "SHEET!RANGE" ) , data COLUMN , FALSE )