Results 1 to 8 of 8

vlookup help, can this be done? (cells J&K filled with G&I data if data in C is a repeat)

Threaded View

  1. #1
    Registered User
    Join Date
    05-23-2018
    Location
    Independence, Mo
    MS-Off Ver
    2016
    Posts
    61

    vlookup help, can this be done? (cells J&K filled with G&I data if data in C is a repeat)

    ok, I am sure I was doing something stupidly simple wrong.

    but I need to get results based on an entered data point.

    example in the spreadsheet:
    enter data in C16
    search column C for the first repeat of data starting at current entry(C16) if found(C9)
    pulls data from column G(G9) and enters it in column J of current entry (J16)
    then pull data from column I (I9) and enters it in column K of current entry (K16)
    Attached Files Attached Files
    Last edited by Mike Luce; 09-09-2019 at 10:46 PM. Reason: found solution from other source

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Vlookup - keeping the leading zeros in a cell to allow the vlookup to work
    By UFBEE1970 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-02-2019, 04:41 PM
  2. Replies: 5
    Last Post: 12-07-2016, 09:18 AM
  3. Replies: 0
    Last Post: 12-26-2013, 01:12 PM
  4. Display Cell within VLookup range that excel thinks matches the VLookup Value
    By headachexcelperson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2013, 04:56 PM
  5. vlookup? match? index? MULTIPLE criteria for vlookup search problem....
    By aborg88 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-11-2013, 09:56 AM
  6. Replies: 5
    Last Post: 07-29-2009, 07:53 AM
  7. vlookup function-Can vlookup command find the data from the 5 sheets.
    By Rishab shah in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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