| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel quotation
I want to quote value of a cell on differnt tabs, location of the cell is
defined in column B. Now i have A(tab name) B C 1 aaa H121 =INDIRECT("'" &A1& "'!H121") How can C1 use B1 in the formula instead of calling "H121" out directly? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel quotation
=indirect("'"&a1&"'!"&b1)
KathyIris wrote: I want to quote value of a cell on differnt tabs, location of the cell is defined in column B. Now i have A(tab name) B C 1 aaa H121 =INDIRECT("'" &A1& "'!H121") How can C1 use B1 in the formula instead of calling "H121" out directly? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel quotation
Do you mean this???
=INDIRECT("'" &A1& "'!" & B1) -- HTH... Jim Thomlinson "KathyIris" wrote: I want to quote value of a cell on differnt tabs, location of the cell is defined in column B. Now i have A(tab name) B C 1 aaa H121 =INDIRECT("'" &A1& "'!H121") How can C1 use B1 in the formula instead of calling "H121" out directly? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel quotation
In the same way A1 was included... you just concatenate the text values you
need (if they are in a cell, like the contents of A1 was, you just use the reference to the cell)... =INDIRECT("'"&A1&"'!"&B1) -- Rick (MVP - Excel) "KathyIris" wrote in message ... I want to quote value of a cell on differnt tabs, location of the cell is defined in column B. Now i have A(tab name) B C 1 aaa H121 =INDIRECT("'" &A1& "'!H121") How can C1 use B1 in the formula instead of calling "H121" out directly? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Single quotation mark in Excel not showing up | Excel Discussion (Misc queries) | |||
| How do I return quotation key to normal in Excel? | Excel Discussion (Misc queries) | |||
| how do i add quotation marks to every item in a column in excel | Excel Discussion (Misc queries) | |||
| How do I produce Automatic Quotation Numbers in Excel? | Excel Discussion (Misc queries) | |||
| Excel Quotation Marks! | Excel Discussion (Misc queries) | |||
Linear Mode
