Display cells dependent on option buttons

Hi,

I'm trying to set up a spreadsheet that displays certain cells dependent on what option buttons are pressed.

For example option box A will have 1-4 in it, as will option box 2 and 3. If combination 1-3-2 is picked i need certain cells to be displayed. if 2-2-4 is picked some other cells are displayed and so on.

The cells will have hyperlink text in them if that's relevant.

Can anyone advise of how best to go about this or what sort of things i should be searching for to learn?

Thank you.

HI,

yeah I've been a little vague in my meaning - sorry

I'm trying to find a way of display certain cells that meat the criteria of a search. These cell would have links in them. I'm trying to find a way of having excel only display the cells which match the criteria chosen from the options boxes.

I've been thinking about this and I'm now of the opinion that my best course of action to achieve this would be to firstly:

have all the cells with links in on a separate worksheet which a value of some sort attached to them.

Then secondly, have three drop down boxes on another worksheet, which have different values attached to them dependent on which option you choose from the drop down list; if the value chosen in the drop down list matches the value of the cell in the other worksheet, then display that cell below.

The drop down list would have clients for example in it and by choosing a particular client, then you would only get to see links relevant to that client.

I hope that explains it better? apologies if it doesn't, I'm a little new at this

Actually; I think I've very nearly solved this...

I've created my lists and drop down menus. I used the "=CONCATENATE" to display the combined values chosen in the drop down menus in a separate cell and create an array with all the combinations possible together with the text i want displaying next to them in the following column.

I've lastly created a =vlookup cell that uses the =concatenate info as a base and finds the cell in the array with the matching info, then display the adjacent cell.

It's all working well accept I don't want the text in the adjacent cell to be displayed until a button is pressed. How do i do that?

I also need a "reset" button that will clear the cells called up via =vlookup and clears the text chosen in the drop down lists. Again any suggestions would be appreciated.

Lastly - the adjacent cells in the array only display text at the moment and I'm going to need them to be hyperlinks eventually. I've tested one just now and the vlookup command is only display the text in the cell and not recognizing it as a hyperlink. Is there someone extra i need to tell it to do?

sorry to have to ask so many questions...