77-AUDIO Posted June 20, 2011 Report Posted June 20, 2011 (edited) =VLOOKUP(B3,Sheet2!$A$3:$P$27,MATCH(E3,Sheet2!$A$3:$P$3,0),0)*G3 This works great, but I need it to display a 0 (zero) instead of the default #N/A for totaling purposes. please help... Edited June 20, 2011 by Twiztid Quote PPI dbl dinDC Level 31.77cubes net tuned to 33htz.DC audio 2.0kCT Pro Audio 8" in front, 6.5 in rear
tdc3187 Posted June 21, 2011 Report Posted June 21, 2011 I think you can change the blank output in the edit menu, preferences. ***I think*** Quote Viper 5902, big 3, 1/0 Rockford wiring, 2 xs d3100, mechman 300a, pioneer avic-z1, 2 dc 12xls, Rockford t2500.1bdcp, Rockford t1000.4ad, Rockford t2 6.5 comps, damplifier Build log: http://www.stevemeadedesigns.com/board/topic/102584-carbon-fusion/
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.