+ Reply to Thread
Results 1 to 4 of 4

Matching part of data in a cell

  1. #1
    Registered User
    Join Date
    01-21-2020
    Location
    UK
    MS-Off Ver
    365
    Posts
    6

    Matching part of data in a cell

    I am trying to match some data and want to know if i can use a formula to do this.

    From the image attached, i want to use the data in Column N, to match against Column A, to populate Column H with data from Column O.
    Eg, to populate H2, Z_GB_0001 is matches the 1st part of A2 (Z_GB_0001_ST005) so therefore H2 would populate with the data in O2.

    Thanks

    Andy
    Attached Images Attached Images

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,785

    Re: Matching part of data in a cell

    The image is hardly readable, and it would help if you attached a sample Excel workbook.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

    Do not try to use the Paperclip icon (Attachments button), as this does not work on this forum.

    Hope this helps.

    Pete

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,040

    Re: Matching part of data in a cell

    Other way round, surely.
    Column N is not matched against column A.
    Instead the first 9 characters of column A are matched against the value in column N and the corresponding value from column O is placed in column H.

    O2 is Auto-Reject which doesn't appear in H2. The value should be Simple Purchase Order from O3 not O2.

    in H2
    =IFERROR(VLOOKUP(LEFT(A2,9),N$2:o$1000,2,0),"*** ERROR - REQUEST_TYPE NOT FOUND ***")
    and copy down the column
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Registered User
    Join Date
    01-21-2020
    Location
    UK
    MS-Off Ver
    365
    Posts
    6

    Re: Matching part of data in a cell

    That worked.

    Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Matching Part names and Part Numbers
    By AM8DVP in forum Excel General
    Replies: 4
    Last Post: 04-04-2019, 11:32 AM
  2. Replies: 8
    Last Post: 04-12-2017, 11:00 AM
  3. [SOLVED] Conditional formatting by matching part characters of cell
    By jilaba in forum Excel General
    Replies: 9
    Last Post: 04-05-2017, 01:57 PM
  4. [SOLVED] Formula for matching any part of a cell against a list in other worksheet
    By Nic812 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-24-2014, 02:11 PM
  5. [SOLVED] aligning two columns - only first part of data is matching
    By krakari in forum Excel General
    Replies: 4
    Last Post: 07-29-2013, 05:57 PM
  6. Replies: 2
    Last Post: 06-13-2013, 03:15 PM
  7. matching part of an entry in a cell
    By Andyd74 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-24-2006, 01:10 PM

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