Home |
Search |
Today's Posts |
#1
|
|||
|
|||
In two workbooks, how do I create a formula that will look at a o.
While working in two workbooks, I would like to create a formula in the first
workbook that looks at a particular column, (example column AE), and not its contents. As it is now, I created a formula to look into cell AE1, but when deleting column AB, column AE becomes column AD, which is not what I want. Help please. Thanks, Dave |
#2
|
|||
|
|||
Dave,
Try using the Offset function, and reference your cells using that. For additional help reference http://www.contextures.com/Dynamic for dynamic range references HTH "socaldave469" wrote: While working in two workbooks, I would like to create a formula in the first workbook that looks at a particular column, (example column AE), and not its contents. As it is now, I created a formula to look into cell AE1, but when deleting column AB, column AE becomes column AD, which is not what I want. Help please. Thanks, Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to Sum a definable range of workbooks | Excel Worksheet Functions | |||
how can i merge 2 workbooks using a formula? | Excel Worksheet Functions | |||
How do I create a formula in Excel that will countif or sumif bef. | Excel Worksheet Functions | |||
How do I create a formula that could have two different outcomes? | Excel Worksheet Functions | |||
How do I create a multi formula IF function in Excel? | Excel Worksheet Functions |