Using the "IF" formula to return a defined list

Will Blyde

New member
Joined
Aug 13, 2013
Messages
1
Reaction score
0
Points
0
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

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
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

Super Moderator
Staff member
Joined
Mar 22, 2011
Messages
357
Reaction score
0
Points
0
Location
New Zealand
Hi Will. Suggest you upload a sample spreadsheet, or further describe what your data looks like and what you want to do.
 
Top