Posted to microsoft.public.excel.worksheet.functions

Bobby6901

external usenet poster

Posts: 1

How do I copy a VLOOKUP into a column and keep a constant array?

I am trying to copy a VOOKUP formula down a column, and
Excel wants to change the reference array as I move to lower rows. How do I
stop that?

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
Vlookup - need the array to be constant	reesrob	Excel Worksheet Functions	2	November 18th 07 02:29 PM
Array Constant?	SayWhatAuto	Excel Discussion (Misc queries)	2	December 30th 06 02:24 PM
Array formula with a constant?	Tester	Excel Worksheet Functions	4	October 31st 06 10:44 PM
array formula with constant	name	Excel Worksheet Functions	2	May 24th 06 05:14 PM
Array constant issue	Sige	Excel Worksheet Functions	16	March 16th 06 02:56 PM

All times are GMT +1. The time now is 04:32 AM.

About Us

"It's about Microsoft Excel"