Try:
=IF(D1="","",INDEX($G$35:$I$35,,MATCH(D1,$F$36:$F$ 38,0)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Meeffas" wrote:
I started witha dropdown box. The user will select one of the 3 conditions
(Balanced, Offensive, Defensive). Using that response the information
inserted into other cells using predetermined data. What I have so far isn't
working, I get a Naming error.

=IF D1=F36,then display G35, else IF D1=F37, then display H35, else display
I35

F36,F37, and F38 are the three choices in the drop down box and G35, H35 and
I35 is the information I would like to put into my other cell. Thank you.