Results 1 to 4 of 4

Reverse lookup with only one search criteria

Threaded View

  1. #1
    Registered User
    Join Date
    08-11-2017
    Location
    England
    MS-Off Ver
    2010
    Posts
    5

    Reverse lookup with only one search criteria

    Hi everyone,
    I have a problem which I'm sure should be simple to solve but for the life of me I can't work it out.

    Below is a snippet of the workbook I'm using, I've combined parts of two sheets into one for this photo:
    On the right hand side is a list of orders being exported from our site.
    On the left is a table of the various product codes we are using.

    All we want to do if for the cell K3 to display the correct product type based on the number in J3 and the table on the left. The amount of products will continue to expand, so it needs to be dynamic.

    I've been using index & match when using a matrix and I have two search criteria, but I'm struggling to solve this with only one.

    Really appreciate any help.

    Thank you,

    Capture.JPG
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] 2 variable search criteria lookup on different tabs? Help!
    By amajor99 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-09-2018, 01:55 PM
  2. [SOLVED] Search Lookup with multiple criteria
    By NotSwank in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-11-2014, 03:37 PM
  3. Replies: 7
    Last Post: 08-04-2013, 03:41 PM
  4. Match/Index/Lookup - Searching From Bottom to Top (A reverse lookup maybe)
    By Neutralizer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-02-2013, 03:55 AM
  5. [SOLVED] Lookup formula required to search for two criteria and return result
    By dave1983 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-12-2012, 03:29 PM
  6. [SOLVED] multi-criteria search lookup fail
    By zfl in forum Excel General
    Replies: 4
    Last Post: 06-16-2012, 09:26 AM
  7. multiple lookup based on two search criteria
    By maacmaac in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-28-2010, 03:33 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