|
Vlookup Col_index_num
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 "I Agree" 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 "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Vlookup Col_index_num
This is for the Vlooup function
-- Regards Mort Australia "Mort Australia" wrote: 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 "I Agree" 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 "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Vlookup Col_index_num
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 "Mort Australia" wrote in message ... 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 "I Agree" 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 "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Vlookup Col_index_num
Sorry, dont understand, can you give me an examole
-- Regards Mort Australia "Charles Williams" wrote: 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 "Mort Australia" wrote in message ... 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 "I Agree" 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 "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Vlookup Col_index_num
=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 "Mort Australia" wrote in message ... Sorry, dont understand, can you give me an examole -- Regards Mort Australia "Charles Williams" wrote: 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 "Mort Australia" wrote in message ... 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 "I Agree" 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 "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Vlookup Col_index_num
Thanks Charles - you have saved me a lot of unnecessary keying!!
-- Regards Mort Australia "Charles Williams" wrote: =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 "Mort Australia" wrote in message ... Sorry, dont understand, can you give me an examole -- Regards Mort Australia "Charles Williams" wrote: 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 "Mort Australia" wrote in message ... 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 "I Agree" 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 "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
| All times are GMT +1. The time now is 12:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com