Dave Lucas
New Member
- Joined
- Dec 15, 2003
- Messages
- 7
I want to use an if statement described below
(IF(MATCH(U5,$AJ5:$BB5,0)>0,U5,if(another statement)) where if the cell u5 is in the listed range then the value of the cell is u5 if it is not then nest another if statement. The problem if the first match does not work it returns an "#N/A" and the second part of the if statement does not kick in. How do I use a qualifier that will recognize the "#N/A" so that the second part of the if statement works?
Thanks
Dave
(IF(MATCH(U5,$AJ5:$BB5,0)>0,U5,if(another statement)) where if the cell u5 is in the listed range then the value of the cell is u5 if it is not then nest another if statement. The problem if the first match does not work it returns an "#N/A" and the second part of the if statement does not kick in. How do I use a qualifier that will recognize the "#N/A" so that the second part of the if statement works?
Thanks
Dave