Rubbish. File A has 100000 entries in column A. File B has 750000 entries in column A with a corresponding value in column B.In column B of file A, try doing "=VLOOKUP, a1, fileB, A:B, 2 false).It just hangs forever.Excel 365 does the calc in two seconds.Waste of time.
