+ Reply to Thread
Results 1 to 3 of 3

Simplifying a formula

  1. #1
    Forum Contributor
    Join Date
    07-22-2012
    Location
    Spain
    MS-Off Ver
    Excel 2008
    Posts
    304

    Simplifying a formula

    Hello,

    Is there a different way of expressing the following formula?

    =VLOOKUP(B6,Pipes,4)*E6 + VLOOKUP(B7,Pipes,4)*E7 + VLOOKUP(B8,Pipes,4)*E8

    I would like to be able to express B6, B7 and B8 as a range (or named range) and the same for E6, E7 and E8


    Thank you very much.

    Kind regards

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Simplifying a formula

    hi there. could you break up the Pipes into 2 parts? if Pipes is G6:J9, then it'll be something like:
    =SUMPRODUCT(LOOKUP(B6:B8,G6:G8,J6:J8)*E6:E8)
    Attached Files Attached Files

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Forum Contributor
    Join Date
    07-22-2012
    Location
    Spain
    MS-Off Ver
    Excel 2008
    Posts
    304

    Re: Simplifying a formula

    Hi benishiryo, yes this helped!

    Thanks!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Simplifying a big formula
    By aureliano in forum Excel General
    Replies: 1
    Last Post: 06-22-2012, 08:14 PM
  2. Simplifying a formula
    By neilpateluk in forum Excel General
    Replies: 3
    Last Post: 01-14-2009, 09:25 AM
  3. Simplifying my formula
    By lordfa9 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-09-2007, 05:33 AM
  4. Simplifying a formula
    By MartinW in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-19-2006, 06:55 AM
  5. Simplifying formula
    By m.cain in forum Excel General
    Replies: 1
    Last Post: 03-24-2006, 07:40 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1