intersection naming
I'm trying to use an intersection for a cell. I want the first term to be
the value that shows up in one cell and the second term to be the value from another cell. I'm having trouble figuring out how to use the single quotes that are needed, along with the value of the cell. Any help? -- Boris |
intersection naming
dont quite follow.the address function work like that using a number for the
row and column where row 1 is the first row in the worksheet (ussually 1) and column 1 is the first column(ussually A). Does that help? -- paul remove nospam for email addy! "BorisS" wrote: I'm trying to use an intersection for a cell. I want the first term to be the value that shows up in one cell and the second term to be the value from another cell. I'm having trouble figuring out how to use the single quotes that are needed, along with the value of the cell. Any help? -- Boris |
intersection naming
Try indirect, eg: in say, A19:
=INDIRECT(A17) INDIRECT(A18) where A17 houses the col header name, A18 contains the row header name -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "BorisS" wrote: I'm trying to use an intersection for a cell. I want the first term to be the value that shows up in one cell and the second term to be the value from another cell. I'm having trouble figuring out how to use the single quotes that are needed, along with the value of the cell. Any help? -- Boris |
All times are GMT +1. The time now is 08:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com