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
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