I see nothing wrong with your formula. The concatenated strings simply aren't finding matching strings.
I tried putting in temporary column 'QUOTA' I2:I6 and in temporary column G 'DATABASE' G2:G6. Then in temporary column 'QUOTA' J2:J6 They match on rows 1 and 2 but return #N/A on the others. Upon close examination this is correct.
|
I |
J |
1 |
|
|
2 |
CAXU812782373936766 |
2 |
3 |
CAXU812782326893886 |
3 |
4 |
MEDU807244752153724 |
#N/A |
5 |
MEDU807244739367624 |
#N/A |
6 |
MEDU807244268938824 |
#N/A |
|
G |
1 |
|
2 |
MEDU8072442752153724 |
3 |
CAXU812782373936766 |
4 |
CAXU812782326893886 |
5 |
MEDU8072442739367624 |
6 |
MEDU8072442268938824 |
Bookmarks