lauren garcia
New Member
- Joined
- Aug 10, 2019
- Messages
- 12
what is the formula to match automatically the second value if the result of the first match is n/a or zero?
thank you!
thank you!
A | B | C | D | E | |
---|---|---|---|---|---|
1 | Value | Match | List | Match | |
2 | a | 10 | b | 1 | |
3 | a | 0 | |||
4 | c | n/a | |||
5 | x | 6 | |||
6 | e | 2 | |||
7 | a | 10 | |||
8 | y | 2 |
Worksheet Formulas
<thead> </thead><tbody> </tbody> |