Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old 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
Default 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   Report Post  
Old 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
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Activex component can't create object Naveen New Users to Excel 1 September 4th 07 02:57 PM
Create a formula based on date jenn Excel Worksheet Functions 3 January 8th 07 04:53 PM
Need to create formula based on date Gary''s Student New Users to Excel 0 November 29th 06 11:32 PM
Need to create formula based on date Eileen New Users to Excel 0 November 29th 06 10:39 PM
Can I create a line graph based on a formula Damo447 Excel Worksheet Functions 2 November 12th 06 09:14 PM


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

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017