Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is it possible to create a VLOOKUP formula based on an ActiveX con
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is it possible to create a VLOOKUP formula based on an ActiveX con
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activex component can't create object | New Users to Excel | |||
Create a formula based on date | Excel Worksheet Functions | |||
Need to create formula based on date | New Users to Excel | |||
Need to create formula based on date | New Users to Excel | |||
Can I create a line graph based on a formula | Excel Worksheet Functions |