Hello,
I am having a mind blank situation regarding a Excel formula
Column
Row A B C D
1 Red 0
2 Red 0
3 Red 0
4 Red 9
5 Red 0
I am using VLookUp on the above data to return a positive value when found of 9
However VLookUp will search for the first criteria of Red and will therefore return a value of 0 ( Zero )
I need a formula that will lookup Red and a positive value and ignore all the zero’s ?
Many thanks
T
I am having a mind blank situation regarding a Excel formula
Column
Row A B C D
1 Red 0
2 Red 0
3 Red 0
4 Red 9
5 Red 0
I am using VLookUp on the above data to return a positive value when found of 9
However VLookUp will search for the first criteria of Red and will therefore return a value of 0 ( Zero )
I need a formula that will lookup Red and a positive value and ignore all the zero’s ?
Many thanks
T