PLEASE HELP - COPY VLOOKUP

[Guest]

Someone tried to help me but I didn't had any results...


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]

$A92 is an absolute column, A92 is relative and changes when copied

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Someone tried to help me but I didn't had any results...
|
|
| 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
|

 

[Guest]

Thank you,

but I don't want to change the "look up value", I want the "colindexnumber"
(from 57 to 58, to 59 etc).

Any other idea?

I also tried to put the column (ie BB:BB) instead of the number but it
didn't work also.

 

[Niek Otten]

It does here

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Thank you,
|
| but I don't want to change the "look up value", I want the "colindexnumber"
| (from 57 to 58, to 59 etc).
|
| Any other idea?
|
| I also tried to put the column (ie BB:BB) instead of the number but it
| didn't work also.
|
| "Niek Otten" wrote:
|
| > $A92 is an absolute column, A92 is relative and changes when copied
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | Someone tried to help me but I didn't had any results...
| > |
| > |
| > | 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
| > |
| >
| >
| >

 

[Guest]

.. I want the "colindexnumber" (from 57 to 58, to 59 etc).

Try replacing the constant col index num: "57" in your vlookup
with: COLUMN(A1)+56
The col index num will now increment correctly when you copy across

---

 

[Guest]

Max Thank you!!!

It worked!

Try replacing the constant col index num: "57" in your vlookup
with: COLUMN(A1)+56
The col index num will now increment correctly when you copy across

---

 

[Guest]

You're welcome !