You should Copy the Formula to Notepad and then copy (from Notepad) to the
second sheet to prevent it referencing the sheet it originally came from.

HTH

" wrote:

I am by no means an excel guru, and I'm needing a little help. I have
numerous cells that are using the following Vlookup formula:
VLOOKUP("Total Amount ("&LEFT($C4,4)&")",Report!$B$1:$E$1000,2,FALSE) )

The "Report" sheet will be present in all subsequent workbooks that I
create. Whenever I copy and paste the formula to another workbook,
Excel places the name of the file in the formula. I.E.:

VLOOKUP("Total Amount ("&LEFT($C15,4)&")",'[Week 14.xls]Report'!$B$1:$E
$1000,2,FALSE)

How can I prevent it from doing this, or is there something that I can
put in the vlookup to tell it to always use the current workbook?

Thanks in advance.