T
Teresita
I have a list of people......
a1:a3 b1:b3
7 Ana
8 Marie
9 Susan
I have the following formula:
=index(a1:b3,match("susan",b1:b3,0),1)
The result is: 9 But if the list does not have Susan, it gave me #N/A
error value.... i need to add the result in a formula...... but with the
error value it is not possible. is there any way to get 0 instead of #N/A
when the formula does not mach the list?
a1:a3 b1:b3
7 Ana
8 Marie
9 Susan
I have the following formula:
=index(a1:b3,match("susan",b1:b3,0),1)
The result is: 9 But if the list does not have Susan, it gave me #N/A
error value.... i need to add the result in a formula...... but with the
error value it is not possible. is there any way to get 0 instead of #N/A
when the formula does not mach the list?