How do I get Excel to display a table on a different worksheet?

[John]

Is there an IF statement I could use so that if the word "Level" is displayed
in cell A1 on sheet 1 then a table from Sheet 2 that is in the cells B2:C3 is
displayed in B2 to C3 on Sheet 1?

 

[Stefi]

Enter in Sheet 1, B2:
=IF($A$1="Level",Sheet 2!B2,"")
and fill it to the right and down!
Regards,
Stefi

„John†ezt írta:

 

[Gareth.Evans]

Is there an IF statement I could use so that if the word "Level" is displayed
in cell A1 on sheet 1 then a table from Sheet 2 that is in the cells B2:C3 is
displayed in B2 to C3 on Sheet 1?

Put this formauls in each respective cell (B2,C2,B3,C3) in sheet 1

Cell B2 =IF(A1 = "level, Sheet2!B2)
Cell C2 =IF(A1 = "level, Sheet2!C2)
Cell B3 =IF(A1 = "level, Sheet2!B3)
Cell C3 =IF(A1 = "level, Sheet2!C3)

 

[John]

I was hoping to get a statement that I would only have to put in one cell as
there is multiple tables that I will have to incorporate into the IF
statement along with the "Level" table

 

[Stefi]

If you name range in sheet2, B2:C3 to "level" then you can write in sheet1,
B2 =level
but still you have to fill it to the right and down.
Stefi


„John†ezt írta:

 

[John]

When I name the range and type:

=level

into a cell it just gives the #VALUE! warning?

 

[Stefi]

No idea, why! Post an example of your data!
Stefi


„John†ezt írta:

 

[Stefi]

Try to use another name! Level being an English word may mean something to an
English language Excel. Mine is a national language version and isn't
bothered by English words.

Meanwhile I found a still simpler way: select the entire destination range
(sheet1, B2:C3), enter in the formula bar
=sourcenamedrange
(the name that you chose instead of level) and confirm it as an array
formula with Ctrl+Shift+Enter!

Stefi


„Stefi†ezt írta: