Remember Me?

#1
October 19th 07, 12:27 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Oct 2007 Posts: 1
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
October 19th 07, 04:41 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jan 2007 Posts: 2,510
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.

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Naveen New Users to Excel 1 September 4th 07 02:57 PM jenn Excel Worksheet Functions 3 January 8th 07 04:53 PM Gary''s Student New Users to Excel 0 November 29th 06 11:32 PM Eileen New Users to Excel 0 November 29th 06 10:39 PM Damo447 Excel Worksheet Functions 2 November 12th 06 09:14 PM

All times are GMT +1. The time now is 03:02 AM.