Return an answer from a column; using an array and a single row ...

[wesrockin]

Thanks for looking at my question.


I have an an array of heights associated with several tree species, I want to transform these values into an integer (1-6). I have a large table of data with hundreds of individual trees with a species name (e.g. white fir) and height (0-300) and I want to assign each into one of these 6 classes. Each species has unique breakpoints for each class, so each column header has a species name with the unique breakpoints in the 6 rows below it, there are 5 columns of species and 1 column with the 6 classes. I want to return the 1-6 class from some kind of vlookup or index match combination, but can't figure it out with my limited abilities

Thanks for any help you can provide!

I want to return the first column; the lookup values are the species (e.g. SP) and then the values in that column (i.e. 0 46 60 84 93 300)

Attachment 246388