I have created two option buttons. Depending on the answer the user selects,
I would like another cell to automatically update with a number. I know you
can do a VLOOKUP to do this when using tables and pages of data, but i am
unsure if i am able to do create this based on an activeX control.

Really need a little more information in the way of actual values and what
the selection of the option button is supposed to tell you to answer your
question properly. However, as a couple of pointers:-

Assume that cell A2 is linked to one of the buttons so that you get True or
False. In cell C2 you might put something like this:-

=IF(A2=TRUE,"Oranges","")

In cell D2 you might put a Vlookup based on the value of C2 something like
this:-

=IF(C2<"",VLOOKUP(C2,$K$2:$L$18,2,FALSE),"")

and if you wanted, you could nest those 2 formulas into one cell something
like this:-

=IF(IF(A2=TRUE,"Oranges","")<"",VLOOKUP(IF(A2=TRU E,"Oranges",""),$K$2:$L$18,2,FALSE),"")

If the above doesn't help then see if you can provide some more information
in the form of an example of the data.

Regards,

OssieMac


"Srisuephanh" wrote:

I have created two option buttons. Depending on the answer the user selects,
I would like another cell to automatically update with a number. I know you
can do a VLOOKUP to do this when using tables and pages of data, but i am
unsure if i am able to do create this based on an activeX control.