+ Reply to Thread
Results 1 to 2 of 2

Cannot use Vlookup for mirror Image of text

  1. #1
    Registered User
    Join Date
    03-13-2009
    Location
    London, England
    MS-Off Ver
    Excel 2016
    Posts
    96

    Cannot use Vlookup for mirror Image of text

    In column A and B, I have a combination of legs achieved by some background work. There are 30 stocks in total and are paired up so 15 Pairs. These pairs are shown in D, which is just a text combination of =A3&B3 etc.

    The 30 stocks have 435 combinations if paired up and are listed in alphabetical order in column I&J. Column L =I3&J3 etc which is text Leg1 and Leg2. Column O = J3&I3 etc which is text Leg2 and Leg1.

    I need to do a Vlookup for the pairs in Column D. Since the pairs shown in Coulmn D can either be Leg1&Leg2 or Leg2&Leg1 (As an example SIE GY EquityVOW GY Equity
    =Leg1&Leg2, SZG GY EquityHEN3 GY Equity= Leg2&Leg1).

    Columns E&F show how the Vlookup works. I cant seem to be able to do a single Vlookup.
    Attached Files Attached Files

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Cannot use Vlookup for mirror Image of text

    Based on the way you've configured your "master list" the only way you can conduct the calc in a single VLOOKUP would be to ensure the criteria is generated in the correct order - eg:

    =VLOOKUP(IF(A3<=B3,A3&B3,B3&A3),L:M,2,FALSE)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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