LinkBack URL
About LinkBacks
Try this instead...=IF(B5="","",SUM(E5:G5)*C5)
edit: also, try this in E5, copied down and across...
=IFERROR(INDEX($M$6:$O$11,MATCH($B5,$K$6:$K$11,0),MATCH(E$4,$M$5:$O$5,0)),"")
Try this instead...=IF(B5="","",SUM(E5:G5)*C5)
edit: also, try this in E5, copied down and across...
=IFERROR(INDEX($M$6:$O$11,MATCH($B5,$K$6:$K$11,0),MATCH(E$4,$M$5:$O$5,0)),"")
Last edited by FDibbins; 06-27-2014 at 08:04 PM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks