PLEASE HELP - VLOOKUP COPY

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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'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.
 
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
 
Back
Top