+ Reply to Thread
Results 1 to 5 of 5

Vlookup same value but two different outcomes

  1. #1
    Forum Contributor
    Join Date
    05-06-2017
    Location
    London, United Kingdom
    MS-Off Ver
    2007
    Posts
    262

    Vlookup same value but two different outcomes

    Hi guys so i am trying to work out how to do it, but how would i go about using vlookup to look for a value with two different outcomes.

    so if in A2 and A3 is a product code of 50022261 and in k2 and k3 i want to put vlookup to look up that product code on another sheet and return both locations how would i do so? as whatever i do it returns the same location.

    Currently using
    Please Login or Register  to view this content.
    but obviously getting the same outcome.

    ill be using vba to paste the formula down column k to like 15,000 cells & then copy n paste values after.

    ill attach a sample workbook of the part im stuck on, thanks
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-30-2014
    Location
    England
    MS-Off Ver
    2007 / 365
    Posts
    246

    Re: Vlookup same value but two different outcomes

    As they have the same product number, is there anything on the Outcome sheet that can be used differentiate those two products on the MERCH sheet?
    For example the MERCH sheet has 'A' against the first product and 'B' against the second, can something like that be added to the Outcome sheet to allow for a unique match?

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    9,897

    Re: Vlookup same value but two different outcomes

    How about
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    05-06-2017
    Location
    London, United Kingdom
    MS-Off Ver
    2007
    Posts
    262

    Re: Vlookup same value but two different outcomes

    Worked perfectly, thanks!

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    9,897

    Re: Vlookup same value but two different outcomes

    You're welcome & thanks for the feedback

+ 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. [SOLVED] IF AND with 3 outcomes
    By RoundaboutCJP in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-09-2018, 10:05 AM
  2. All possible Outcomes for C to WIN overall ?
    By Rahzelsmh in forum Excel General
    Replies: 0
    Last Post: 04-06-2016, 11:13 AM
  3. [SOLVED] VLOOKUP with multiple outcomes
    By Hessing in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-28-2013, 09:42 AM
  4. Multiple Outcomes from Vlookup
    By Groves29 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 09-10-2013, 11:52 AM
  5. [SOLVED] Generate all possible outcomes
    By AmpleFlame in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-06-2013, 07:46 PM
  6. VLOOKUP with a number of outcomes horizontal
    By jimipop in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-16-2013, 06:44 AM
  7. 256 possible outcomes
    By MarkN in forum Excel General
    Replies: 8
    Last Post: 06-28-2006, 03: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