+ Reply to Thread
Results 1 to 4 of 4

Can I combined Vlookup and Average?

  1. #1
    Registered User
    Join Date
    05-25-2017
    Location
    Perth
    MS-Off Ver
    Office 365
    Posts
    1

    Can I combined Vlookup and Average?

    Hi

    I would appreciate some help to set up a type Lookup formula.
    The document contains prices for pumps parts. Column A has the pump model, Column B has the unique part codes (each pump model has a list of parts that fit into it) . In Row 2 you have the different regions the prices come from, and below that in Row 3 you have the customers names. Each Column under the customer name has the price they pay for the specific parts

    I need a formula that would allow us to search by part, or by pump model (showing all relevant part associated with that pump model) and show next to the result the lowest price in the data for that part, the highest as well as the average. We would also like to be able to select by which region it should be searched.
    I am not sure if you can have a Vlookup combined with an average, highest and lowest formula.

    Please help
    Thanks
    Kind Regards
    Gerhard
    Last edited by Gerhardvv; 05-25-2017 at 01:52 AM. Reason: Got flaged for wrong title

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Urgent formula help needed

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

    and ...

    Attach a sample workbook (not image).

    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

    Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Can I combined Vlookup and Average?

    why not use averageif?
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Can I combined Vlookup and Average?

    Gerhardvv welcome to the forum

    upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    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

+ 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. Replies: 2
    Last Post: 01-15-2016, 09:20 AM
  2. IF, AND formula needed - Urgent
    By kiwiram in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-20-2012, 06:23 AM
  3. Needed urgent help from a excel master to provide and explain a formula
    By amitav in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-15-2012, 04:21 AM
  4. Count formula needed...urgent
    By senjuti.sarkar in forum Excel General
    Replies: 14
    Last Post: 03-09-2012, 02:00 AM
  5. Replies: 1
    Last Post: 12-16-2011, 07:21 AM
  6. Help Needed Urgent
    By BiggieD in forum Excel General
    Replies: 7
    Last Post: 04-19-2006, 12:04 PM
  7. [SOLVED] *URGENT* - Complex formula needed
    By Stacy in forum Excel General
    Replies: 1
    Last Post: 07-01-2005, 01:05 PM

Tags for this Thread

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