I'm sorry. The answer has got to be out here somewhere, but I feel like I am beating my head against the floor.
A one sheet workbook.
Four named vertical ranges of 50 items each (Lets pretend each of the four range names is a plant types).
50 named horizontal ranges of 4 items each (each range name is a 2 letter state abbreviations).
For simplicity, let's say that the resultant table is of the words "No", "Poor","Good" "Great".
The user selects a state and a "plant" from two validation set drop down lists. The workbook change event is triggered, and there goes the code to determine the word or value in the cell that is at the intersection of the two, let's say again for simplicity "MI" and "Banana Tree", which would probably result in a "NO".
I can write the names of the ranges separated by a space after an = in a cell and easily get the result, but I sure can't figure out how to transfer the result of two drop-down boxes into same formula (at least not so it works), and all the more worse to do so via VBA. I would LOVE to be able to do so both ways, but just one would save me. Please help before my head explodes.
Bookmarks