Using the "IF" formula to return a defined list

[Will Blyde]

I am working on a spreadsheet at work where I have two tables of information, and depending on the answer to a set question, will depend on the table that needs to be shown.

I am trying to use an "IF" formula to return the lists, however this isn't working! Can anyone help?

Cheers,
Will

[NBVC]

Perhaps something like:

=INDEX(IF(A1="X",$X$1:$Y$10,$Z$1:$AA$10),ROWS($A$1:$A1),COLUMNS($A$1:A$1))

where A1 contains the answer that defines table, and X1:Y10 and Z1:AA10 contain the 2 tables to choose from.

the formula when copied down and to next column will extract the 2 table columns.

[JeffreyWeir]

Hi Will. Suggest you upload a sample spreadsheet, or further describe what your data looks like and what you want to do.