How to quote cells when "IF" word is involved

M

Ming

On Sheet1, I have a data set (C1:C100) based on the input of cell A1.
When A1 has various method choices,say,"method 1","method 2","method
3", each cell in the data set will have a new value accordingly.
(=IF(A1="method 1",formula1,IF(A1="method 2",formula2,formula3))

I want to quote those three data sets on Sheet2. A lousy way is I could
just duplicate Sheet1, set A1 to different value and quote data sets
from different sheets.

Is it possible to quote three data sets simultaneously from Sheet1?

Thanks,
Ming
 
M

Ming

Thanks, Max !
I was stuck in something and forgot to check this thread.

The 2-variable table is new to me and it does solve the single data set
case.
Unfortunately, I have a lot of data sets in Sheet1(That's why I am
seeking a way to avoid adding more content to the crowded sheet), each
changes with A1 accordingly.
Should I build a table for each set or the table can be expanded to
accommodate all data sets?

As to the A1 value in the example above, I used data validation so I
can only choose from three options.

Good weekend
 
Top