Posted to microsoft.public.excel.programming

hideki[_17_] hideki[_17_] is offline

external usenet poster

Posts: 1

Using named range in vlookup

I've never test this but for the range to work I think you can do lik
this:

StockCode = Item
with Sheets("STOCK")
lookup1 = Application.WorksheetFunction.VLookup(Item, _
.Range(.Columns("A:a"), .Columns("e:e")), 5,False)
end with

Best regards

--
hidek
-----------------------------------------------------------------------
hideki's Profile: http://www.excelforum.com/member.php...fo&userid=1890
View this thread: http://www.excelforum.com/showthread.php?threadid=40139

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, concatenated named range	patti	Excel Worksheet Functions	4	March 14th 10 03:20 AM
VLOOKUP with a Named Range argument	modernminstrel	Excel Worksheet Functions	1	October 13th 08 04:11 PM
Vlookup in a named range	tuph	Excel Worksheet Functions	7	May 29th 06 02:23 AM
Vlookup in large named range	KemS	Excel Worksheet Functions	3	November 23rd 05 06:14 PM
Vlookup on named range	kev	Excel Programming	1	September 23rd 04 12:23 PM

All times are GMT +1. The time now is 11:44 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us