I'm working on a two worksheets.
The formula is as follows:

=VLOOKUP($A92;'[Q306 MME Pricing Aug 06 CUSTOMER COPY v5 (2).xls]PRICE
LIST'!$A:BE;57;0)

I want to copy the formula to one cell on the right and turns as follows:

=VLOOKUP($A92;'[Q306 MME Pricing Aug 06 CUSTOMER COPY v5 (2).xls]PRICE
LIST'!$A:BF;57;0)

My problem is that the coll index number does not change...

that means I have to change it manually for 50 collumns.

PLEASE HELP

Please do not post to multiple groups in separate posts.
Your question has been answered an hour ago in other newsgroup

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"I.C.E." wrote in message ...
| I'm working on a two worksheets.
| The formula is as follows:
|
| =VLOOKUP($A92;'[Q306 MME Pricing Aug 06 CUSTOMER COPY v5 (2).xls]PRICE
| LIST'!$A:BE;57;0)
|
| I want to copy the formula to one cell on the right and turns as follows:
|
| =VLOOKUP($A92;'[Q306 MME Pricing Aug 06 CUSTOMER COPY v5 (2).xls]PRICE
| LIST'!$A:BF;57;0)
|
| My problem is that the coll index number does not change...
|
| that means I have to change it manually for 50 collumns.
|
| PLEASE HELP
|

Sorry, but I didn't realize it, because for a few minutes, when I tried to
post, an error message was coming up.

"Niek Otten" wrote:

Please do not post to multiple groups in separate posts.
Your question has been answered an hour ago in other newsgroup

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"I.C.E." wrote in message ...
| I'm working on a two worksheets.
| The formula is as follows:
|
| =VLOOKUP($A92;'[Q306 MME Pricing Aug 06 CUSTOMER COPY v5 (2).xls]PRICE
| LIST'!$A:BE;57;0)
|
| I want to copy the formula to one cell on the right and turns as follows:
|
| =VLOOKUP($A92;'[Q306 MME Pricing Aug 06 CUSTOMER COPY v5 (2).xls]PRICE
| LIST'!$A:BF;57;0)
|
| My problem is that the coll index number does not change...
|
| that means I have to change it manually for 50 collumns.
|
| PLEASE HELP
|

Why are so many posts duplicated even on the same forum.
99% seem to come from discussions.microsoft.com
Of all methods of posting to a Microsoft forum you'd think there would be
something done about it.
Any other forum I'd start treating the posts as spam and complain to
abuse@...

Steve

On Wed, 11 Oct 2006 10:50:06 +0100, Niek Otten wrote:

Please do not post to multiple groups in separate posts.
Your question has been answered an hour ago in other newsgroup