| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a cell reference within a cell reference in a formula
I believe it is possible to use a cell reference as one component of a
formula but I can't remember how. What I want the overall formula to do is pick up the letter component from another cell reference - can anyone help please? Thanks David |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using a cell reference within a cell reference in a formula
Nel post oups.com
*david* ha scritto: I believe it is possible to use a cell reference as one component of a formula but I can't remember how. What I want the overall formula to do is pick up the letter component from another cell reference - can anyone help please? Thanks David Hi David, You can use the INDIRECT function. Try to check the on line guide, then If you should need any help, post your formula here. I'll show you an example: =SUM(INDIRECT(A1&"2:"&A1&"100")) so if in A1 there is B the above formula is equivalent to: =SUM(B2:B100) Be aware that if you use the INDIRECT function in connection with another file, for example: =SUM(INDIRECT([WB2]Sheet1!A1&"2:"&[WB2]Sheet1!A1&"100")) also the second file should be open to have a result; if not, you will have a #REF! error. -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using a cell reference within a cell reference in a formula
Thank you - I'll try it
David Franz Verga wrote: Nel post oups.com *david* ha scritto: I believe it is possible to use a cell reference as one component of a formula but I can't remember how. What I want the overall formula to do is pick up the letter component from another cell reference - can anyone help please? Thanks David Hi David, You can use the INDIRECT function. Try to check the on line guide, then If you should need any help, post your formula here. I'll show you an example: =SUM(INDIRECT(A1&"2:"&A1&"100")) so if in A1 there is B the above formula is equivalent to: =SUM(B2:B100) Be aware that if you use the INDIRECT function in connection with another file, for example: =SUM(INDIRECT([WB2]Sheet1!A1&"2:"&[WB2]Sheet1!A1&"100")) also the second file should be open to have a result; if not, you will have a #REF! error. -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function/ formula to output a cell reference | Excel Worksheet Functions | |||
| How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
| copied formula has correct cell reference, but result of original | Excel Worksheet Functions | |||
| Reference to One Cell stays the same in Different Formula | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Linear Mode
