Great stuff, didn't know of this function before! Thanks a lot!

Is there a way of using this as part of a reference though? So could I
have something like:

=VLOOKUP(A1, [excelFile.xls]INDIRECT(A2)!A1:C10, 2, FALSE)


--
anar_baku
------------------------------------------------------------------------
anar_baku's Profile: http://www.excelforum.com/member.php...o&userid=18259
View this thread: http://www.excelforum.com/showthread...hreadid=489099