Hi,
I’ve been struggling to build a quick and speedy VBA (Excel 2013) to search for a match of 3 variables obtained from one worksheet that has 3k records, to a record in another worksheet that has over 800k records. I want to find the record that has a match for 1 variable in a cell in one column and a match for 2 variables in a cell in another column. Once I find the record, then I want to get data from other columns in that row and place on the other worksheet that I get my 3 variables. Many thanks in advance!!! Kelly
VarSub = “ARAPAHO EAST”
Sometimes lot is “LOT” or “LT”
VarLot1 = “LOT 22”
VarLot2 = “LT 22”
VarBlk = “BLK 8”
Returns match for Row 7 so I know where to get the other data for the record
Excel 2013 32 bit
<tbody>
</tbody>
<tbody>
</tbody>
I’ve been struggling to build a quick and speedy VBA (Excel 2013) to search for a match of 3 variables obtained from one worksheet that has 3k records, to a record in another worksheet that has over 800k records. I want to find the record that has a match for 1 variable in a cell in one column and a match for 2 variables in a cell in another column. Once I find the record, then I want to get data from other columns in that row and place on the other worksheet that I get my 3 variables. Many thanks in advance!!! Kelly
VarSub = “ARAPAHO EAST”
Sometimes lot is “LOT” or “LT”
VarLot1 = “LOT 22”
VarLot2 = “LT 22”
VarBlk = “BLK 8”
Returns match for Row 7 so I know where to get the other data for the record
Excel 2013 32 bit
W | X | |
---|---|---|
1 | LEGAL1 | LEGAL2 |
2 | CAMP WISDOM WEST | BLK D LT 4 |
3 | ARAPAHO EAST 1 REV | BLK 3 LOT 25 |
4 | ARAPAHO EAST 1 REV | BLK 4 LOT 12 |
5 | ARAPAHO EAST 1 REV | BLK 4 LOT 16 |
6 | ARAPAHO EAST 2B | BLK 7 LOT 5 |
7 | ARAPAHO EAST 2B | BLK 8 LOT 22 |
8 | ARAPAHO EAST 2B | BLK 8 LOT 37 |
9 | ARAPAHO EAST 5 | BLK B LT 1 |
10 | COUNTRY CLUB PARK ESTATES | BLK D LOT 8 |
<tbody>
</tbody>
Sheet: Sheet1 |
<tbody>
</tbody>