+ Reply to Thread
Results 1 to 5 of 5

if x is a match in this selection then display the info in the column next to it

Hybrid View

  1. #1
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: if x is a match in this selection then display the info in the column next to it

    I removed the Data Validation from PO Tracker column D (Customer Address) and insert the below formula

    =INDEX(CONCATENATE('PO Settings'!$E$3:$E$500,", ",'PO Settings'!$F$3:$F$500,", ",'PO Settings'!$G$3:$G$500),MATCH($C14,'PO Settings'!$C$3:$C$500,0))

    For C7:C10

    =INDEX('PO Settings'!$D$3:$D$500,MATCH($C$6,'PO Settings'!$C$3:$C$500,0))
    =INDEX('PO Settings'!$E$3:$E$500,MATCH($C$6,'PO Settings'!$C$3:$C$500,0))
    =INDEX('PO Settings'!$F$3:$F$500,MATCH($C$6,'PO Settings'!$C$3:$C$500,0))
    =INDEX('PO Settings'!$G$3:$G$500,MATCH($C$6,'PO Settings'!$C$3:$C$500,0))

    This is an array formula so do not just press the ENTER key. Press CTRL + SHIFT + ENTER
    Last edited by Syrkrasi; 12-06-2017 at 11:57 AM.

+ 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. [SOLVED] Show row if cell contents in column A match filter selection from column B
    By SHANNON MAUGHAN in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2017, 01:28 AM
  2. [SOLVED] Display colour based on info in another column
    By kevwilsondj in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-04-2015, 12:47 PM
  3. Match names in two separate column if = then pull info in 3 column
    By Bevg in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-07-2013, 08:31 PM
  4. Textboxes within Userform to display info based on combobox selection
    By alter54 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-28-2012, 12:40 PM
  5. Replies: 6
    Last Post: 12-19-2010, 03:35 PM
  6. Display info from a drop down selection.
    By Excelcuriously in forum Excel General
    Replies: 5
    Last Post: 04-23-2010, 05:28 AM

Tags for this Thread

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