求助各位大虾:
如何将下列几个公式组合或者有更好的建议,请给出意见。
=VLOOKUP($C$19,'Data-TRZ'!$A$5:$J$30,IF($AC$32="1:20",4,""),FALSE)
=VLOOKUP($C$19,'Data-TRZ'!$A$5:$J$30,IF($AC$32="1:30",5,""),FALSE)
=VLOOKUP($C$19,'Data-TRZ'!$A$5:$J$30,IF($AC$32="1:50",6,""),FALSE)
=VLOOKUP($C$19,'Data-TRZ'!$A$5:$J$30,IF($AC$32="1:80",7,""),FALSE)
=VLOOKUP($C$19,'Data-TRZ'!$A$5:$J$30,IF($AC$32="1:100",8,""),FALSE)
=VLOOKUP($C$19,'Data-TRZ'!$A$5:$J$30,IF($AC$32="1:120",9,""),FALSE)
=VLOOKUP($C$19,'Data-TRZ'!$A$5:$J$30,IF($AC$32="1:160",9,""),FALSE)
|