Bulk vlookup?
Hi there,
I have a huge data set in 3 columns. The first column labels the datapoints
in columns 2 and 3. There are 5 labels, so there are many datapoints with the
same label. They are not in order (and can't be.) Is there anyway to use a
vlookup or something similar to go to the first column, look for label x and
return all the data rows in a list on a new spreadsheet? A bit like sumif
without the sum.
Thanks!
|