How about this ?
=IF(OR(E7={3,5,7}),VLOOKUP(E2,Project!A19:O236,E7+10,0),0)
Does anyone know how to shorten the formula.
=IF(E7<>3,0,VLOOKUP(E2,Project!A19:O236,13,FALSE))+IF(E7<>5,0,VLOOKUP(E2,Project!A19:O236,15,FALSE))+IF(E7<>7,0,VLOOKUP(E2,Project!A19:O236,17,FALSE))
Many thanks to all
Mike
How about this ?
=IF(OR(E7={3,5,7}),VLOOKUP(E2,Project!A19:O236,E7+10,0),0)
Superb anwser Juan
Thanks
Mike
Like this thread? Share it with others