Hello again.

am working with a 3 tier nomenclature system (for biological systems)

the 3 tier are:
family
genus
species


What I want are linked comboboxes in a userform that take their rowsource from a match in the previous colomn

(ie. if I select the bear family in the family combobox then the genus combox will populate with range 3:100 in the bear column (using something like hlookup as the bear column will have a header that matches the family combox entry).

I will also need to return additional information from the column next to the bear colum (genus descriptions). is there a way to be a match offset in an array for that when I select a genus, it will find that one and return the text of one cell to the left?