| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Which criteria was matched? | Excel Discussion (Misc queries) | |||
| Return matched value 2 criteria | Excel Worksheet Functions | |||
| Delete all rows if criteria not matched | Excel Discussion (Misc queries) | |||
| Return Formula results to specific row of matched criteria | Excel Worksheet Functions | |||
| SUMPRODUCT - Exclude LAST Row of Matched Criteria (Month & Year) | Excel Worksheet Functions | |||
Hybrid Mode
