I have an excel sheet with Criteria A, Criteria B, and Output C with about 332,000 rows of data. I have a list of input A & Input B on a separate sheet. I am trying to find output C with an approximate match of criteria A and B. I have the below formula that works well with a sample data of 21 rows but no matter what I do, it is not working with my full dataset. What am I doing wrong?
| Column H | Column I | Column J |
|---|---|---|
| 35.12345 | -82.456123 | IOO45678 |
| 34.56789 | -83.12398 | IA001234 |
If my input data is in cell V3 (corresponding to Column H), and cell W3 (corresponding to column I), my formula goes as such:
=INDEX(
J2:J332000,
MATCH(MIN(ABS(H2:H332000-V3) & MIN(ABS(I2:I332000-W3),
ABS(H2:H332000-V3) & ABS(I2:I332000-W3),
0
)
)
I am getting a #N/A error. I have double checked the data, the formula but I am not seeing any mistakes. Also I tried this same formula and it works in a sample dataset of 20 rows with the same data. I am expecting an approximate match from the first two columns and data returned from the third column