Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I adress diferent Sheets in same Book according to a cellv
I´m working with a Excelbook where I use diferent sheets in the same book for
collecting information depending on the value of a cell in an annother sheet. So, is there some way to use a cellvalue as a sheet adress to annother sheet in the same book, and put it in to a Lookupformula. For instance, if the a cellvalue in "Sheet A" is "1" I will collect information from "Sheet X" with a Lookup formula, and wish to use the cellvalue as a an adress to "Sheet X". If the value in the cell is "2" I wish to collect the information from annother Sheet, and so on. The different informationsheets are identical in formats, so the only information that differs in a Lookup formula is the sheetadress. I wish to avoid a IF formula. I´m using Excel 2002 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I adress diferent Sheets in same Book according to a cellv
Use
=INDIRECT("'Sheet "&A1&"'!B10") If you have your Sheet number in A1 then enter the above in B1 it will retrun the value in 'Sheet A'!B10 if A1 contains A Basically construct a string which returns the cell address you want and put that inside INDIRECT... "Tom N" wrote: I´m working with a Excelbook where I use diferent sheets in the same book for collecting information depending on the value of a cell in an annother sheet. So, is there some way to use a cellvalue as a sheet adress to annother sheet in the same book, and put it in to a Lookupformula. For instance, if the a cellvalue in "Sheet A" is "1" I will collect information from "Sheet X" with a Lookup formula, and wish to use the cellvalue as a an adress to "Sheet X". If the value in the cell is "2" I wish to collect the information from annother Sheet, and so on. The different informationsheets are identical in formats, so the only information that differs in a Lookup formula is the sheetadress. I wish to avoid a IF formula. I´m using Excel 2002 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I adress diferent Sheets in same Book according to a c
Thank You Sheeloo!
You solved my problem! Tom N "Sheeloo" skrev: Use =INDIRECT("'Sheet "&A1&"'!B10") If you have your Sheet number in A1 then enter the above in B1 it will retrun the value in 'Sheet A'!B10 if A1 contains A Basically construct a string which returns the cell address you want and put that inside INDIRECT... "Tom N" wrote: I´m working with a Excelbook where I use diferent sheets in the same book for collecting information depending on the value of a cell in an annother sheet. So, is there some way to use a cellvalue as a sheet adress to annother sheet in the same book, and put it in to a Lookupformula. For instance, if the a cellvalue in "Sheet A" is "1" I will collect information from "Sheet X" with a Lookup formula, and wish to use the cellvalue as a an adress to "Sheet X". If the value in the cell is "2" I wish to collect the information from annother Sheet, and so on. The different informationsheets are identical in formats, so the only information that differs in a Lookup formula is the sheetadress. I wish to avoid a IF formula. I´m using Excel 2002 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I sort the order of sheets in a book? | Excel Discussion (Misc queries) | |||
Get Data From Diferent Sheets | Excel Discussion (Misc queries) | |||
Macro for part of W/book sheets | Excel Discussion (Misc queries) | |||
Can you call functions between sheets in the same book in excel? | Excel Worksheet Functions | |||
How do I reconcile two sheets with in a .xls book? | New Users to Excel |