+ Reply to Thread
Results 1 to 3 of 3

Min Look Up Issue

  1. #1
    Registered User
    Join Date
    03-18-2009
    Location
    Solihull
    MS-Off Ver
    Excel 2003
    Posts
    53

    Min Look Up Issue

    Hi
    Have a question around a MINIMUM value look up value
    I'm fine with finding the lowest value in selection of data, however, on enclosed I want it to return two relevant details surrounding the min value itself
    In the is case it would be factory name and MOQ

    Please help!

    thanks
    Attached Files Attached Files

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: Min Look Up Issue

    Hi,

    Try these...

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    03-18-2009
    Location
    Solihull
    MS-Off Ver
    Excel 2003
    Posts
    53

    Re: Min Look Up Issue

    GENIUS!

    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. Listbox issue + Setfocus after property Issue
    By naveenmarapaka in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-27-2018, 09:42 PM
  2. Replies: 7
    Last Post: 12-15-2017, 12:14 AM
  3. [SOLVED] Insert shift down issue macro issue
    By CC64 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-15-2012, 10:57 PM
  4. Issue with X axis values NOT graphing on Scatter graph and issue with Labels
    By lmausolf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-17-2012, 07:20 AM
  5. Issue - Image button issue - by JBeaucaire
    By Vaibhav in forum Suggestions for Improvement
    Replies: 2
    Last Post: 05-06-2012, 07:35 AM
  6. [SOLVED] Issue - Attachment issue - by Simon Lloyd
    By Vaibhav in forum Suggestions for Improvement
    Replies: 16
    Last Post: 03-16-2012, 06:56 PM
  7. [SOLVED] Issue -Joke thread issue - Mordred
    By Vaibhav in forum Suggestions for Improvement
    Replies: 2
    Last Post: 02-17-2012, 01:31 PM

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