Vlookup in VBA. How can I?
 

I have some sections in the sheet where I have named cells to be used for a
Vlookup. I was wondering if there is a way within my VBA code to use vlookup
and access those sections to get the data I want?

Vlookup in VBA. How can I?
 

Yep.

dim res as variant
dim lookuprng as range
dim myVal as string 'or whatever

set lookuprng = worksheets("sheet99").range("a:e")
myVal = "Test"
res = application.vlookup(myval, lookuprng,3,false)
if iserror(res) then
'same as #n/a
msgbox "not found"
else
msgbox res
end if



WannaBeExceller wrote:

I have some sections in the sheet where I have named cells to be used for a
Vlookup. I was wondering if there is a way within my VBA code to use vlookup
and access those sections to get the data I want?

--

Dave Peterson

Vlookup in VBA. How can I?
 

Hello WannaBeExceller,

myValue = WorksheetFunction.VLookUp(Lookup_Vakue, Table_Array,
Col_Index_Num, [Range_lookup])

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=503003

Vlookup in VBA. How can I?
 

I tried this but it is having a problem with assigining values to the
myValue. Could you explain how it is working please. I do not understand the
workings of Table_Array and range_lookup? Thanks in advance.

"Leith Ross" wrote:


Hello WannaBeExceller,

myValue = WorksheetFunction.VLookUp(Lookup_Vakue, Table_Array,
Col_Index_Num, [Range_lookup])

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=503003

Vlookup in VBA. How can I?
 

Hello WannaBeExceller,

Those are the names of the arguments that the function requires. See
Dave's example and you will see what the arguments are and how they are
used.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=503003

Vlookup in VBA. How can I?
 

Thank you very much Leith. Two thumbs way up!

"Leith Ross" wrote:


Hello WannaBeExceller,

Those are the names of the arguments that the function requires. See
Dave's example and you will see what the arguments are and how they are
used.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=503003