that should work but I have another hitch to this problem,

the "3.85" that I want the cell to recognize when "25" is checked on the
combo box comes from "sheet 2" of the workbook. What would happen if I change
the "3.85" to "8.75"? Would the Vlookup have to changed?

"Bob Phillips" wrote:

Link the combox to a cell, and then just use a simple lookup

=A2*LOOKUP(A2,{25,30,40},{3.85,4.25,2.75})

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"rdwngr23" wrote in message
...
how can i get a specific value in a cell based on what is marked from a
checkbox?

if i have a combo box with 25, 30, 40 in cell b2 and i want cell b3 to
calculate a formula based on the "25" being checked (ie: if "25" is
checked
multiply that (25) by 3.85)

am trying to use this for a home business - need help please!!!