software

I need to drag the formula accross columns and increase the col_index_num by
1 for each new column.
The array will increase by a letter automatically if the $in not in place in
front of the selected columns
ie $A:$C will remain whereas A:C will increase
However the col_index_num always remains the same.
It should move as the array does utilising the $

Regards
Mort
Australia

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...lic.excel.misc

This is for the Vlooup function
--
Regards
Mort
Australiaquot;Mort Australiaquot; wrote:

gt; I need to drag the formula accross columns and increase the col_index_num by
gt; 1 for each new column.
gt; The array will increase by a letter automatically if the $in not in place in
gt; front of the selected columns
gt; ie $A:$C will remain whereas A:C will increase
gt; However the col_index_num always remains the same.
gt; It should move as the array does utilising the $
gt;
gt; Regards
gt; Mort
gt; Australia
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...lic.excel.misc

Hi Mort,

You can use the COLUMN() function for this: see help for a description

Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

quot;Mort Australiaquot; gt; wrote in message
...
gt;I need to drag the formula accross columns and increase the col_index_num
gt;by
gt; 1 for each new column.
gt; The array will increase by a letter automatically if the $in not in place
gt; in
gt; front of the selected columns
gt; ie $A:$C will remain whereas A:C will increase
gt; However the col_index_num always remains the same.
gt; It should move as the array does utilising the $
gt;
gt; Regards
gt; Mort
gt; Australia
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow
gt; this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...lic.excel.misc
Sorry, dont understand, can you give me an examole
--
Regards
Mort
Australiaquot;Charles Williamsquot; wrote:

gt; Hi Mort,
gt;
gt; You can use the COLUMN() function for this: see help for a description
gt;
gt; Charles
gt; ______________________
gt; Decision Models
gt; FastExcel 2.2 Beta now available
gt; www.DecisionModels.com
gt;
gt; quot;Mort Australiaquot; gt; wrote in message
gt; ...
gt; gt;I need to drag the formula accross columns and increase the col_index_num
gt; gt;by
gt; gt; 1 for each new column.
gt; gt; The array will increase by a letter automatically if the $in not in place
gt; gt; in
gt; gt; front of the selected columns
gt; gt; ie $A:$C will remain whereas A:C will increase
gt; gt; However the col_index_num always remains the same.
gt; gt; It should move as the array does utilising the $
gt; gt;
gt; gt; Regards
gt; gt; Mort
gt; gt; Australia
gt; gt;
gt; gt; ----------------
gt; gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; gt; Agreequot; button in the message pane. If you do not see the button, follow
gt; gt; this
gt; gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; gt; click quot;I Agreequot; in the message pane.
gt; gt;
gt; gt; www.microsoft.com/office/comm...lic.excel.misc
gt;
gt;
gt;

=Vlookup(LookupValue,LookupArray,column(d1))

would give 4 as the column_index_num and this will increment to e, f (5,6)
etc as you drag across.

or you can use Column()-2 for example to give the current column number -2--
Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

quot;Mort Australiaquot; gt; wrote in message
...
gt; Sorry, dont understand, can you give me an examole
gt; --
gt; Regards
gt; Mort
gt; Australia
gt;
gt;
gt; quot;Charles Williamsquot; wrote:
gt;
gt;gt; Hi Mort,
gt;gt;
gt;gt; You can use the COLUMN() function for this: see help for a description
gt;gt;
gt;gt; Charles
gt;gt; ______________________
gt;gt; Decision Models
gt;gt; FastExcel 2.2 Beta now available
gt;gt; www.DecisionModels.com
gt;gt;
gt;gt; quot;Mort Australiaquot; gt; wrote in
gt;gt; message
gt;gt; ...
gt;gt; gt;I need to drag the formula accross columns and increase the
gt;gt; gt;col_index_num
gt;gt; gt;by
gt;gt; gt; 1 for each new column.
gt;gt; gt; The array will increase by a letter automatically if the $in not in
gt;gt; gt; place
gt;gt; gt; in
gt;gt; gt; front of the selected columns
gt;gt; gt; ie $A:$C will remain whereas A:C will increase
gt;gt; gt; However the col_index_num always remains the same.
gt;gt; gt; It should move as the array does utilising the $
gt;gt; gt;
gt;gt; gt; Regards
gt;gt; gt; Mort
gt;gt; gt; Australia
gt;gt; gt;
gt;gt; gt; ----------------
gt;gt; gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt;gt; gt; suggestions with the most votes. To vote for this suggestion, click the
gt;gt; gt; quot;I
gt;gt; gt; Agreequot; button in the message pane. If you do not see the button, follow
gt;gt; gt; this
gt;gt; gt; link to open the suggestion in the Microsoft Web-based Newsreader and
gt;gt; gt; then
gt;gt; gt; click quot;I Agreequot; in the message pane.
gt;gt; gt;
gt;gt; gt; www.microsoft.com/office/comm...lic.excel.misc
gt;gt;
gt;gt;
gt;gt;
Thanks Charles - you have saved me a lot of unnecessary keying!!
--
Regards
Mort
Australiaquot;Charles Williamsquot; wrote:

gt; =Vlookup(LookupValue,LookupArray,column(d1))
gt;
gt; would give 4 as the column_index_num and this will increment to e, f (5,6)
gt; etc as you drag across.
gt;
gt; or you can use Column()-2 for example to give the current column number -2
gt;
gt;
gt; --
gt; Charles
gt; ______________________
gt; Decision Models
gt; FastExcel 2.2 Beta now available
gt; www.DecisionModels.com
gt;
gt; quot;Mort Australiaquot; gt; wrote in message
gt; ...
gt; gt; Sorry, dont understand, can you give me an examole
gt; gt; --
gt; gt; Regards
gt; gt; Mort
gt; gt; Australia
gt; gt;
gt; gt;
gt; gt; quot;Charles Williamsquot; wrote:
gt; gt;
gt; gt;gt; Hi Mort,
gt; gt;gt;
gt; gt;gt; You can use the COLUMN() function for this: see help for a description
gt; gt;gt;
gt; gt;gt; Charles
gt; gt;gt; ______________________
gt; gt;gt; Decision Models
gt; gt;gt; FastExcel 2.2 Beta now available
gt; gt;gt; www.DecisionModels.com
gt; gt;gt;
gt; gt;gt; quot;Mort Australiaquot; gt; wrote in
gt; gt;gt; message
gt; gt;gt; ...
gt; gt;gt; gt;I need to drag the formula accross columns and increase the
gt; gt;gt; gt;col_index_num
gt; gt;gt; gt;by
gt; gt;gt; gt; 1 for each new column.
gt; gt;gt; gt; The array will increase by a letter automatically if the $in not in
gt; gt;gt; gt; place
gt; gt;gt; gt; in
gt; gt;gt; gt; front of the selected columns
gt; gt;gt; gt; ie $A:$C will remain whereas A:C will increase
gt; gt;gt; gt; However the col_index_num always remains the same.
gt; gt;gt; gt; It should move as the array does utilising the $
gt; gt;gt; gt;
gt; gt;gt; gt; Regards
gt; gt;gt; gt; Mort
gt; gt;gt; gt; Australia
gt; gt;gt; gt;
gt; gt;gt; gt; ----------------
gt; gt;gt; gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; gt;gt; gt; suggestions with the most votes. To vote for this suggestion, click the
gt; gt;gt; gt; quot;I
gt; gt;gt; gt; Agreequot; button in the message pane. If you do not see the button, follow
gt; gt;gt; gt; this
gt; gt;gt; gt; link to open the suggestion in the Microsoft Web-based Newsreader and
gt; gt;gt; gt; then
gt; gt;gt; gt; click quot;I Agreequot; in the message pane.
gt; gt;gt; gt;
gt; gt;gt; gt; www.microsoft.com/office/comm...lic.excel.misc
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;