Posted to microsoft.public.excel.misc

Dave Peterson Dave Peterson is offline

external usenet poster

Posts: 35,218

VLOOKUP using a tab name to reference the lookup range

Oops! I had a typo:

=vlookup(a2,indirect("'" & $a$1 & "'!a:e"),5,false)

timmulla wrote:

--
Regards,

timmulla

--

Dave Peterson

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 - dynamic range reference?	aseanor	Excel Discussion (Misc queries)	7	August 17th 06 11:32 PM
VLOOKUP keeping array lookup reference	rebdk	Excel Discussion (Misc queries)	3	July 4th 06 08:46 PM
VLOOKUP range lookup	xtreme_fac	Excel Worksheet Functions	1	December 18th 05 10:47 AM
Range Lookup in VLookup ?'s	Bronco_Junkie	Excel Worksheet Functions	1	November 2nd 05 08:53 AM
use a cell to reference a range in a vlookup	Dan	Excel Discussion (Misc queries)	4	July 27th 05 07:36 PM

All times are GMT +1. The time now is 06:09 AM.

About Us

"It's about Microsoft Excel"