Posted to microsoft.public.excel.programming

Yossi evenzur[_2_] Yossi evenzur[_2_] is offline

external usenet poster

Posts: 21

vlookup on changing range

Hi
I need to the syntax for running a Vlookup on a fixed array, but each time
the size of the array is changing. is there any command for this or can i use
a variable that will stand for range each time?

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
Changing the range for averages with out changing the formula.	JessLRC	Excel Worksheet Functions	0	April 20th 10 03:10 PM
How do I copy a vlookup formula without changing the data range?	VickyL872	Excel Worksheet Functions	2	May 27th 08 06:45 PM
VLOOKUP, changing ranges	Sarah	Excel Discussion (Misc queries)	1	August 21st 07 07:38 PM
changing data in range of vlookup	Josie	Excel Discussion (Misc queries)	1	November 1st 05 05:42 PM
Changing the vlookup cell	jamesjra	Excel Programming	1	December 12th 03 01:10 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us