Is this possible?
I've just realised that the data I need to use in one of my worksheets comes from a table with hundreds of thousands of rows.
I only need to retrieve values with Project numbers from a list in another worksheet (of which there are about 600)
Is it possible to perform a VLOOKUP (or just any database query in EXCEL, with values in a worksheet as the criteria???
Matt
London (UK)
I've just realised that the data I need to use in one of my worksheets comes from a table with hundreds of thousands of rows.
I only need to retrieve values with Project numbers from a list in another worksheet (of which there are about 600)
Is it possible to perform a VLOOKUP (or just any database query in EXCEL, with values in a worksheet as the criteria???
Matt
London (UK)