Shorten formula
as a formula, i would imagine.......
=(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)
but the actual matching part would be in your other formula. say you
put this in Z7, then as Bernd said above, you just use MATCH (Z7,0) in
your big formula.
susan
On Mar 26, 2:59 pm, "brownti via OfficeKB.com" <u31540@uwe wrote:
I tried to do this but with no luck. Do i want to input the MATCH(....) part
as a formula or as text? I havent ever done anything using helped cells.
thanks
Bernd wrote:
Hello,
You use the formula part
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)
THREE times in your big formula.
Move this part into another cell, say Z7 and substitute the 3
instances in your original formula by Z7.
If you want to simplify your formula further, get the other parts
INDEX(...,MATCH()) out into helper cells, too. With a little cost of
additional helper cells you will be rewarded by a huge gain in better
overview/simplicity.
Regards,
Bernd
--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-programming/200703/1- Hide quoted text -
- Show quoted text -
|