Excel Formula

Associate
Joined
20 Sep 2005
Posts
2,023
Location
Wilderness of ESSEX
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
 
Back
Top Bottom