VLookup if criteria matched
 

I have a spreadsheet of some 12000 rows - some data in the columns is static
- some will be entered by a user (who may also add additional columns) and
the rest of the data will be imported from a seperate spreadsheet. I am not
allowed to use access.

I had set up a vlookup formula to "import" the data from the seperate
spreadsheet - but this makes the receiving spreadsheet too slow. Is there
any way based on the primary key to only have a look up on the records which
match the records on the seperate spreadsheet - or does anyone have any other
ideas?

Thanks

VLookup if criteria matched
 

you can use macro to open that file and copy the data that match your
condition.

"Miss Marple" wrote:

I have a spreadsheet of some 12000 rows - some data in the columns is static
- some will be entered by a user (who may also add additional columns) and
the rest of the data will be imported from a seperate spreadsheet. I am not
allowed to use access.

I had set up a vlookup formula to "import" the data from the seperate
spreadsheet - but this makes the receiving spreadsheet too slow. Is there
any way based on the primary key to only have a look up on the records which
match the records on the seperate spreadsheet - or does anyone have any other
ideas?

Thanks