Trying to make a spreadsheet to do the following:
I need to take a table of data from a sheet and load each of 5 columns into a seperate array. I want to then be able to give an arbitrary value into an input cell on one sheet and search its coresponding array in order to fill out the rest of the values that would be in the same "row" in the table if such a row were to exist.
I'm stuck on trying to figure out how to get this to work, and think I'm probably not even putting the data into arrays correctly. Would appreciate any tips/help.
I need to take a table of data from a sheet and load each of 5 columns into a seperate array. I want to then be able to give an arbitrary value into an input cell on one sheet and search its coresponding array in order to fill out the rest of the values that would be in the same "row" in the table if such a row were to exist.
I'm stuck on trying to figure out how to get this to work, and think I'm probably not even putting the data into arrays correctly. Would appreciate any tips/help.