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

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

Moderator's Note:

Welcome to the forum since your new to the forum may i suggest you to attach a real workbook. Typing data from a picture or paste text from your post into a spreadsheet as a hindrance to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

Regards,
Vladimir

look attachment. tell me if this is what you want.
Thanks.

Copy of excel_forum_example.xlsx

Nice to hear that.
Your welcome.

You can mark this thread as solved. Thanks. Look below my signature.