Hello!
I am using a lookup function to extract a few pieces of data from a spreadsheet i receive monthly. Currently, to use my function, I first have to define my arrays before I can sort into an ascending order. All in all, this requires about 200 arrays to be defined to use a rather simple lookup function: =LOOKUP("Logged-in",andrea1,andreaT1) Andrea1 being the whole data set for Andrea and AndreaT1 being one column of data in Andrea's data set. Am I using the wrong function entirely? Am I missing a key concept of the lookup function? Any input is appreciated.
Thanks!
I am using a lookup function to extract a few pieces of data from a spreadsheet i receive monthly. Currently, to use my function, I first have to define my arrays before I can sort into an ascending order. All in all, this requires about 200 arrays to be defined to use a rather simple lookup function: =LOOKUP("Logged-in",andrea1,andreaT1) Andrea1 being the whole data set for Andrea and AndreaT1 being one column of data in Andrea's data set. Am I using the wrong function entirely? Am I missing a key concept of the lookup function? Any input is appreciated.
Thanks!