| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get Excel to display a table on a different worksheet?
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get Excel to display a table on a different worksheet?
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: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get Excel to display a table on a different worksheet
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" wrote: 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: 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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get Excel to display a table on a different worksheet
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: 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" wrote: 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: 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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get Excel to display a table on a different worksheet
When I name the range and type:
=level into a cell it just gives the #VALUE! warning? "Stefi" wrote: 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: 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" wrote: 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: 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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get Excel to display a table on a different worksheet
No idea, why! Post an example of your data!
Stefi €˛John€¯ ezt Ć*rta: When I name the range and type: =level into a cell it just gives the #VALUE! warning? "Stefi" wrote: 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: 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" wrote: 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: 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? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I get Excel to display a table on a different worksheet
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: No idea, why! Post an example of your data! Stefi €˛John€¯ ezt Ć*rta: When I name the range and type: =level into a cell it just gives the #VALUE! warning? "Stefi" wrote: 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: 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" wrote: 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: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to display 12-12-34 as it is in excel worksheet? | Excel Discussion (Misc queries) | |||
| How to display selected table entries from another worksheet? | Excel Worksheet Functions | |||
| Excel worksheet display #### | Excel Discussion (Misc queries) | |||
| Display specific rows from table on other worksheet | Excel Discussion (Misc queries) | |||
| Display excel formula on worksheet | Excel Worksheet Functions | |||
Linear Mode
