I'm sorry. The answer has got to be out here somewhere, but I feel lik
I am beating my head against the floor.

A one sheet workbook.

Four named vertical ranges of 50 items each (Lets pretend each of th
four range names is a plant types).

50 named horizontal ranges of 4 items each (each range name is a
letter state abbreviations).

For simplicity, let's say that the resultant table is of the word
"No", "Poor","Good" "Great".

The user selects a state and a "plant" from two validation set dro
down lists. The workbook change event is triggered, and there goes th
code to determine the word or value in the cell that is at th
intersection of the two, let's say again for simplicity "MI" an
"Banana Tree", which would probably result in a "NO".

I can write the names of the ranges separated by a space after an = i
a cell and easily get the result, but I sure can't figure out how t
transfer the result of two drop-down boxes into same formula (at leas
not so it works), and all the more worse to do so via VBA. I would LOV
to be able to do so both ways, but just one would save me. Please hel
before my head explodes

--
brucem
-----------------------------------------------------------------------
brucemc's Profile: http://www.excelforum.com/member.php...fo&userid=3287
View this thread: http://www.excelforum.com/showthread.php?threadid=52875