Casey Harrington
New Member
Match() Returning #N/A when matches exist.
Column [C] calculates a difference, B-A
Column [D] looks for the result using Match()
[C] contains =B1-A1
[D] contains =MATCH(C1,$B$1:$B$6, 0)
A B C D
1 -47.69 1937.52 1985.21 2
2 601.77 1985.21 1383.44 3
3 601.77 1383.44 781.67 #N/A
4 124.7 781.67 656.97 #N/A
5 -40 656.97 696.97 6
6 -56.79 696.97
Why do rows 3 and 4, column [D], return "#N/A"?
Column [C] calculates a difference, B-A
Column [D] looks for the result using Match()
[C] contains =B1-A1
[D] contains =MATCH(C1,$B$1:$B$6, 0)
A B C D
1 -47.69 1937.52 1985.21 2
2 601.77 1985.21 1383.44 3
3 601.77 1383.44 781.67 #N/A
4 124.7 781.67 656.97 #N/A
5 -40 656.97 696.97 6
6 -56.79 696.97
Why do rows 3 and 4, column [D], return "#N/A"?
Attachments
Last edited by a moderator: