Moving external sheet to new tab in new doc

[RodneyC]

I have three documents I'm trying to merge into one.

Doc 1 - Has a tab named "Destination" using this code in column C that reads from doc 2, tab CallSign Lookup

=VLOOKUP(A6,'C:\Users\WorkStuff\Documents\Monthly Reporting\December\[CallSignLookup.xlsx]CallSign Lookup'!$Q:$T,4,FALSE)

All works as it is needed. I have copy/pasted this entire tab into a new tab in doc 3

Doc 2 - Data from the CallSign Lookup tab had been copy/pasted into doc 3 and given the same name "CallSign Lookup" as it currently has in doc 2.

Doc 3 - I've gone to the new "Destination" tab and where I have =VLOOKUP(A6,'C:\Users\WorkStuff\Documents\Monthly Reporting\December\[CallSignLookup.xlsx]CallSign Lookup'!$Q:$T,4,FALSE) I have replaced with

=VLOOKUP(A6'CallSign Lookup'!$Q:$T,4,FALSE)

Thinking it would read from the tab within the doc. It isn't. When I hit enter to make it work, it opens a window asking me to select the appropriate file, then tab and it changes the code to:

=IFERROR(VLOOKUP(A5,CallSign '[Lookup]CallSign Lookup'!$Q:$T,4,FALSE),"-")

and doesn't produce the result I'm expecting.

It seems I'm missing something obvious. Any ideas?


Thanks in advance

 

[Fluff]

When I hit enter to make it work, it opens a window asking me to select the appropriate file,

This means you do not have have a sheet in the same workbook as the formula called 'CallSign Lookup' check for typos & leading/trailing spaces.

 

[RodneyC]

This means you do not have have a sheet in the same workbook as the formula called 'CallSign Lookup' check for typos & leading/trailing spaces.

Thanks. I got it working.

 

[Fluff]

Glad it's sorted & thanks for the feedback.