Using control toolbox's option buttons to switch between vlookup tables

I have 2 vlookup tables (A1:B2) and (A4:B5). The values in each cell are as follows:

A1=Male
A2=Female
B1=Man
B2=Woman

A4=Male
A5=Female
B4=Bull
B5=Cow

Cell A7 is where i will paste either the text "Male" or "Female" into. Cell A8 is where i wish to see the result displayed.

Question: How do i set up 2 option buttons (available from the control toolbox) with option1 labelled as "Human" and option2 as "Animal", such that:
- When i select the Human option and paste the text "Male" into cell A7, the result in cell A8 displays "Man"
Similarly:
-select Human option, paste "Female", result is "Woman"
-select Animal option, paste "Male", result is "Bull"
-select Animal option, paste Female, result is "Cow"

I'm new to excel's control toolbox, and am only able to implement the first part (the Human part) with vlookup by keying into cell A8 the following:
=VLOOKUP(A7,$A$1:$B$2,2,FALSE). Basically looking for guidance how to use option buttons to point the vlookup function at the correct table.


Thank you

Hi Andy,

I just realised my error in phrasing the problem using a scenario with 2 tables, resulting in the suggestion using the IF function.

In actual fact, the scenario i should have described involves at least 3 tables (or more as my situation requires me to be able to make the solution scalable for any number of tables).

That's why i was thinking perhaps using radio buttons would help simplify matters (e.g. if i have 4 tables, then i can have 4 radio buttons where each radio button corresponds to a different table). Maybe i'm wrong about the IF function not being able to handle this situation neatly, but i'm open to your thoughts please.

Apologies for the error.

Hi Andy,

What if the lookup variables are not common to the different tables? This is the case in my situation, where only some of the lookup variables are common, but most of the lookup variables are only unique to a particular table.

(To clarify on what i mean by "lookup variables", they are the "male" and "female" terms which are common to both tables in the scenario presented here).

Thanks