I have 2 large data extracts that I work with. The first one has approx 12,000 rows of data and lists every single account. The account number is in column C
The second extract has over 33,000 rows of data. It contains one line for every single payment made this financial year. The account number is also in column C
There is a field in the first workbook that I would like to add to the second workbook, but I'm having trouble trying to figure out how to phrase my formula.
I want the contents of column D from Wkbk1added to Workbook 2.
The information is located on a sheet named Data.
I've tried ^=VLOOKUP(C3,'[Wkbk1.xls]Data'!$A$1:$EN$12859,4,FALSE)
Can anyone let me know what I am doing wrong?