Hello,

Going carzy here, thanks in advance.

Have done several vlookups, but now have a problem. When entering the table
array (by clicking in the corner on the excel worksheet) it enters the file
name, but not the file location on my computer, and then the reference is
invalid. I looked at some old versions I did, and the vlookup entered the
file address. Thanks for any insight.

When you close that other workbook, the formula will adjust to include the drive
and path.

Steve B wrote:

Hello,

Going carzy here, thanks in advance.

Have done several vlookups, but now have a problem. When entering the table
array (by clicking in the corner on the excel worksheet) it enters the file
name, but not the file location on my computer, and then the reference is
invalid. I looked at some old versions I did, and the vlookup entered the
file address. Thanks for any insight.

--

Dave Peterson