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?

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?

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