Not sure how the detail pasted in below will look to you, but it's the
way I always put it together. Easy when you know....and a great little
tool.

And I have no idea about AutoComplete I'm afraid - but hope this gets
you going in the meantime.

Have a great day!

Chris

-------------------------------------------------------------

A B C D E
1 Cell Link input range
2 2 1 Apple
3 2 Orange
4 3 Pear
5 4 Cherry

=VLOOKUP(A2,D2:D5,2,FALSE) This is the value you want to return from
the Combo Box choice.


--
Big Chris

Very experienced with excel in general and formulae but just started to
learn VBA....and it's hard!!
------------------------------------------------------------------------
Big Chris's Profile: http://www.excelforum.com/member.php...fo&userid=1350
View this thread: http://www.excelforum.com/showthread...hreadid=505670