+ Reply to Thread
Results 1 to 3 of 3

Case Sensitive Vlookup plus returning a value

Hybrid View

  1. #1
    Registered User
    Join Date
    08-26-2011
    Location
    San Francisco
    MS-Off Ver
    Excel 2010
    Posts
    1

    Case Sensitive Vlookup plus returning a value

    I was hoping that someone would know how to use Vlookup using the case sensitive function and also return a value that was in another column. An example is below

    A1 KK B1 Blue C1 Ab
    A2 AB B2 Black C2 JJ
    A3 Ab B3 Green C3 AB
    A4 kk B4 Red C4 KK

    So with the above I would like to have C1 match exactly (case sensitive) to anything in column A and if there is a match I would like to have it fill in a value that is in the B column in the same row, to a new column as where the match was found in the A column Results would look like this

    A1 KK B1 Blue C1 Ab D1 Green
    A2 AB B2 Black C2 JJ D2
    A3 Ab B3 Green C3 AB D3 Black
    A4 kk B4 Red C4 KK D4 Blue

    Anybody have any idea?

  2. #2
    Valued Forum Contributor
    Join Date
    05-23-2011
    Location
    Lahore PK
    MS-Off Ver
    Excel 2007, 2013
    Posts
    627

    Re: Case Sensitive Vlookup plus returning a value

    attach file could be helpful
    Attached Files Attached Files
    Azam
    If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
    For prompt answer, be descriptive, concise, short, direct, and to-the-point.

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Case Sensitive Vlookup plus returning a value

    Using your specific example:

    C1:
    =IFERROR(LOOKUP(9.99E+307,FIND($C1,$A$1:$A$4),$B$1:$B$4),"")
    copied down to C4

+ 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