Combo Boxes

A

abbeville

I have built 3 templates of which 2 work perfectly. The 3rd one has m
puzzled. Below is a copy of the result I'm trying to get from my comb
box.

Game Description Value Comments 4
1 Select 0
2 5 Pin 5 Pin 5 Pin Lanes
3 10 Pin 10 Pin 10 Pin Lanes
4 Custom test
I select 1,2,0r 3 & I get my proper result. When I choose Custom I ge
the result for 3. I've checked the assignment unde
"insert","name","define"& that is alright. I've checked the assignmen
for the combo box itself & it is alright. The Formul
(VLOOKUP(Bowling!$E$!,Game,3) is alright. I've cleared the cell
involved completely & redone everything with the same results.
Does anybody know what I might have missed?
Do
 
D

Dave Peterson

=vlookup() has a fourth parm that says to look for exact matches.

I don't understand your post, but maybe...

=VLOOKUP(Bowling!$E$#,Game,3,false)
(not sure what $e$! means either in your original formula)
 
Top