Posted to microsoft.public.excel.misc

Confusicous Confusicous is offline

external usenet poster

Posts: 23

Vlookup formula copy

I have a Vlookup formula that I want to copy over but everytime I do it
changes...Example: Original formula =VLOOKUP(A4,'P35'!$A$2:$H$83,7,FALSE)
when I copy and paste right next to it I get
=VLOOKUP(B4,'P35'!$A$2:$H$83,7,FALSE)...Actually what I need is the B4 to
remain A4 and if its possible to get the 'P35' to go to 'P36'...I am open to
any thoughts or ideas. Thanks in advance

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 VLookup formula from one spreadsheet to another	[email protected]	Excel Discussion (Misc queries)	4	May 10th 21 03:58 PM
Copy part of VLOOKUP formula?	absfl	Excel Discussion (Misc queries)	4	April 19th 09 08:08 PM
How do i copy a vlookup formula into other cells going right	km440	Excel Worksheet Functions	1	December 12th 08 10:53 AM
Vlookup Copy Formula	Joe K.	Excel Worksheet Functions	2	November 19th 08 03:34 PM
Copy VLOOKUP Formula	EMarre	Excel Discussion (Misc queries)	4	October 21st 05 04:05 PM

All times are GMT +1. The time now is 08:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us