Sorry Gary, wasn't as clear as Id like to be there.

What im hoping for is to be able to use vlookup where the table_arra
is the most recently created file in a specific folder.

I do not know how to program in VBA so Im hoping to find a built i
function or a udf that is available that I could use with vlookup.

Thanks again for the hel

--
jaden4
-----------------------------------------------------------------------
jaden41's Profile: http://www.excelforum.com/member.php...fo&userid=2801
View this thread: http://www.excelforum.com/showthread.php?threadid=47521