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
|