Mike

Your question is very vague. If you have a combobox from the 'forms'
toolbar then you can set up a lookup table in a hidden sheet and then use
the index of the selection to look it up using the INDEX function.

Perhaps post back with some more information on what you currently have and
I'm sure someone will help.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Mike" wrote in message
...
how do i assign 7 different sale types to have 7 different percentage
values