+ Reply to Thread
Results 1 to 2 of 2

Lookup OR Find value of Colum F in Column G and Provide output in Column H

  1. #1
    Registered User
    Join Date
    10-25-2012
    Location
    Noida
    MS-Off Ver
    Excel 2010
    Posts
    2

    Lookup OR Find value of Colum F in Column G and Provide output in Column H

    I want to lookup/find the value of Column F in Column G and need a specific output in Column H.

    Explanation of Columns:

    Column F: Value to be looked up
    Column G: Values in which we need to look up/find the value
    NOTE: Values in Column G are present in the format P-Value (i.e. P-Contact Planning and Executions,P-Customer Acquisition, P-New Business and/or Renewal Processing) OR S-Value (i.e. S-Contact Planning and Executions,S-Customer Acquisition, S-New Business and/or Renewal Processing)
    Column H: Output Column

    I am explaining my problem with two examples below:

    1. I need to find the value present in cell F2 i.e. "Contact Planning and Execution" in cell G2 i.e. "P-Contact Planning and Execution,P-Customer Acquisition, P-New Business and/or Renewal Processing" and if "Contact Planning and Execution" is present in G2 then given me "P-Contact Planning and Executions" as an output in cell H2 (Output in this case will be "P-Contact Planning and Execution")

    2. I need to find the value present in cell F7 i.e. "Payment Processing" in cell G7 i.e. "S-Claims Investigation,P-Claims Lifecycle Management,P-Claims Notification,S-Payment Processing" and if "Payment Processing" is present in G7 then given me "S-Payment Processing" as an output in cell H7 (Output in this case will be "S-Payment Processing")

    I am also attaching the excel sheet in which there are 9 rows only, however I need a macro which would work for several rows below. I tried various formulae but its not working at my end.

    Request you to help me and provide me with suitable solution. Thanks!

    Regards,
    Pankaj
    Attached Files Attached Files

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Lookup OR Find value of Colum F in Column G and Provide output in Column H

    Okay.. use below formula:-

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


    see attachment:- Compare Sheet.xlsx



    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ 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