Shorten formula
 

You have been asked several times to fully describe what you are trying to
do.

--
Don Guillett
SalesAid Software

"brownti via OfficeKB.com" <u31540@uwe wrote in message
news:6f9f8e6a7d3a4@uwe...
I need help shortening a formula. Here is what i have:

=IF($A$9,INDEX('[Master Material Pricing.xls]Master Material'!$K$3:$K$677,
MATCH(I36&$U$17&$J38,'[Master Material Pricing.xls]Master
Material'!$C$3:$C
$677&'[Master Material Pricing.xls]Master Material'!$E$3:$E$677&'[Master
Material Pricing.xls]Master
Material'!$G$3:$G$677,0)),IF($A$11,INDEX('[Master
Material Pricing.xls]Master Material'!$L$3:$L$677,MATCH(I36&$U$17&$J38,'
[Master Material Pricing.xls]Master Material'!$C$3:$C$677&'[Master
Material
Pricing.xls]Master Material'!$E$3:$E$677&'[Master Material
Pricing.xls]Master
Material'!$G$3:$G$677,0)),IF($A$13,INDEX('[Master Material
Pricing.xls]Master
Material'!$M$3:$M$677,MATCH(I36&$U$17&$J38,'[Master Material Pricing.xls]
Master Material'!$C$3:$C$677&'[Master Material Pricing.xls]Master
Material'!
$E$3:$E$677&'[Master Material Pricing.xls]Master
Material'!$G$3:$G$677,0)),"")
))

Thats with the master material list open. When it is closed the formula
is
too long to display. Is there maybe a macro that could be run when a
button
is clicked? this formula repeats many times in the sheet. Thanks.

--
Message posted via http://www.officekb.com