Results 1 to 17 of 17

Lookup returning results in alphabetical order

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-08-2005
    MS-Off Ver
    Microsoft 365
    Posts
    812

    Lookup returning results in alphabetical order

    Hi,

    I have data arranged as shown in columns A and B in the attached file.

    I would like to create a formula in D2, which will be copied down the column, that will report the product names shown in column A, if they are listed as Grade1 in column B, in alphabetical order.

    Can someone please suggest a formula that will accomplish this? (I would prefer to use a formula rather than a pivot table or filtering).

    Thanks
    Attached Files Attached Files
    Last edited by andrewc; 11-26-2013 at 06:51 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Lookup on 1 criteria but returning multiple results
    By swingding in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-08-2013, 05:18 AM
  2. Lookup not returning expected results
    By syphlix in forum Excel General
    Replies: 4
    Last Post: 03-08-2011, 04:16 PM
  3. Returning multiple results for one lookup value
    By Lizzietish11 in forum Excel General
    Replies: 5
    Last Post: 01-29-2009, 03:09 PM
  4. Lookup Returning Multiple Results
    By joe1182 in forum Excel General
    Replies: 4
    Last Post: 02-01-2006, 08:02 AM
  5. [SOLVED] Filesearch returning files not in alphabetical order?
    By General in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-23-2005, 04:06 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