+ Reply to Thread
Results 1 to 2 of 2

Lookup/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/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 Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

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

    Hi,

    Does
    Please Login or Register  to view this content.
    in H2 copied down help?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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