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