Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 36

VLookup Range Help

I would like to have the "Range" portion of the VLOOKUP command be populated
from a user input. Is this possible?

Ex: A2 has the formula VLOOKUP(1,A4:C12,1,TRUE) works. Instead, I would
like for cell A1 to have the value: "A4:C12" and the formula in A2 to be
VLOOKUP(1,A1,1,TRUE). I would like to avoid macros.

Thanks in advance.

-Chris

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
using vlookup for a range of cells	mmpfa07	Excel Worksheet Functions	2	May 4th 07 11:25 PM
vlookup range changes	Hobbes2006	Excel Worksheet Functions	3	April 18th 06 07:07 PM
Vlookup where range changes	Greg	Excel Worksheet Functions	1	March 17th 06 11:41 PM
Vlookup for range, help	dark_snowboy	Excel Worksheet Functions	3	January 20th 06 06:19 PM
Vlookup - Range	Mark	Excel Discussion (Misc queries)	1	April 15th 05 05:52 PM

All times are GMT +1. The time now is 01:00 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us