Shortening this if/Vlookup formula

Mikest · Mar 13th, 2002, 07:14 PM

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

Juan Pablo González · Mar 13th, 2002, 08:14 PM

How about this ?

=IF(OR(E7={3,5,7}),VLOOKUP(E2,Project!A19:O236,E7+10,0),0)

Mikest · Mar 13th, 2002, 08:20 PM

Superb anwser Juan
Thanks
Mike

Mar 13th, 2002, 08:14 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	How about this ? =IF(OR(E7={3,5,7}),VLOOKUP(E2,Project!A19:O236,E7+10,0),0) __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 07:14 PM	#1
Mikest New Member Join Date: Mar 2002 Posts: 20	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

Mar 13th, 2002, 08:20 PM	#3
Mikest New Member Join Date: Mar 2002 Posts: 20	Superb anwser Juan Thanks Mike