+ Reply to Thread
Results 1 to 3 of 3

Compare two same string value and return the third value

  1. 03-01-2018, 06:36 AM #1
    erickhawe
    erickhawe is offline
    Registered User
    Join Date
    04-01-2014
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    4

    Compare two same string value and return the third value

    Hi,

    How can i compare two exact string (sheet 1 = peter, sheet 2 peter) and return the third string value ("IT") from two sheets.

    Thank you!
    Regards
    eric

    For example Sheet 1:

    Peter
    James
    Mary


    Sheet 2

    Peter IT
    James Finance
    Mary HR
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-01-2018, 06:39 AM #2
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,727

    Re: Compare two same string value and return the third value

    Where is the IT supposed to come from?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 03-01-2018, 06:40 AM #3
    PaulM100
    PaulM100 is offline
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: Compare two same string value and return the third value

    =VLOOKUP(B1,Sheet2!$B$2:$C$5,2,0)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Script to Search for a specific String then return cell values above that String-4
    By owensjb2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-03-2015, 01:28 AM
  2. [SOLVED] Compare digits within a cell and then return a string for each comparison
    By bibu in forum Excel General
    Replies: 2
    Last Post: 04-14-2014, 02:48 PM
  3. [SOLVED] Compare a string of values to a specific of value and return the header
    By huy_le in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-19-2013, 10:02 PM
  4. [SOLVED] IF range of cells contains string of text, return contents of cell where string is found
    By nobodyukno in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-03-2013, 09:56 AM
  5. Extract Alpha from A String and Compare with another String!
    By aywen in forum Excel General
    Replies: 1
    Last Post: 08-23-2007, 01:10 PM
  6. Compare a string in two columns, if match then append string from third column
    By Londonderry in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-22-2007, 03:41 PM
  7. String compare doesn't compare?
    By Ken Soenen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-16-2006, 11:45 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1