Posted to microsoft.public.excel.misc

I.C.E.

external usenet poster

Posts: 10

PLEASE HELP - VLOOKUP COPY

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy/Paste how to avoid the copy of formula cells w/o calc values	Dennis	Excel Discussion (Misc queries)	10	March 2nd 06 10:47 PM
Copy without Hidden Cols - How	abrogard	Excel Discussion (Misc queries)	1	July 15th 05 07:54 AM
Copy VLookup Values	Karen	Excel Worksheet Functions	3	July 12th 05 04:50 PM
reminder notifications in a column	L Mieth	Excel Discussion (Misc queries)	6	June 10th 05 11:00 AM
VLOOKUP not working	Scott	Excel Worksheet Functions	3	November 12th 04 08:06 PM

All times are GMT +1. The time now is 10:55 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us