Using Option buttons with vlookup
 

I have a couple of vlookups in my spreadsheet and based on which option
(radio) button the user selects is the vlookup table it goes to.

Any sample code out there for this?

Using Option buttons with vlookup
 

I don't have sample code for this, but you might get more assistance if you
try someting and post the code for what you have.
--
HTH,
Barb Reinhardt



"syndr" wrote:

I have a couple of vlookups in my spreadsheet and based on which option
(radio) button the user selects is the vlookup table it goes to.

Any sample code out there for this?

Using Option buttons with vlookup
 

I added a couple of optionbuttons from the forms toolbar and placed a groupbox
(from the forms toolbar) around them.

I assigned the linked cell to A1.

Then i built a couple of tables (b1:c2 and D1:E2) and added a value to lookup to
A2.

This formula worked ok for me:
=IF(A1=0,"",VLOOKUP(A2,IF(A1=1,$B$1:$C$2,$D$1:$E$2 ),2,FALSE))

syndr wrote:

I have a couple of vlookups in my spreadsheet and based on which option
(radio) button the user selects is the vlookup table it goes to.

Any sample code out there for this?

--

Dave Peterson