PLEASE HELP - VLOOKUP COPY

[I.C.E.]

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

 

[Niek Otten]

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'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
|

 

[I.C.E.]

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

 

[SteveW]

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