Here's a working sample for the earlier response, Mike:
http://cjoint.com/?iusfBXwNsw
mike.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mike" wrote:
Max
When I tried the formula below, received blank cell. Maybe the True part, "
", is misplaced in the formula.
Additionally, I needed the sheet to display only 3 cells, A1, B1 and C1
with A1 and B1 being a drop down selection list and C1 displaying the
correct value out of 4 possible choices, as or right now all choices in a1
and b1 are listed.
Thanks for your help.

--
mike