+ Reply to Thread
Results 1 to 4 of 4

Copy adjacent cell data based on ranged criteria.

  1. 05-05-2013, 02:53 PM #1
    Nneakz
    Nneakz is offline
    Registered User
    Join Date
    05-05-2013
    Location
    Hertfordshire
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question Copy adjacent cell data based on ranged criteria.

    Hey all!

    Long time lurker on this forum, taken alot of help in the past, so ive had to register!

    There is one problem ive ran into though on my excel adventures.

    I have two tables of data. I2:I37 (text) + J2:J37 (number).

    How can i find in the range J2:J37 a cell reference: in this case L2 in the range, then once found copy the cell adjacent to it from the I2:I37 range?

    Im total stumped, ive tried IF / VLOOKUPs to no evail!

    Any help is appreciated!

    File attatched as my explaining has confused many of you im sure heh

    help_totalORders.xlsx
    Last edited by Nneakz; 05-05-2013 at 03:48 PM.
    Reply With QuoteRegister To Reply
  2. 05-05-2013, 03:26 PM #2
    aydeegee
    aydeegee is offline
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: Copy adjacent cell data based on ranged criteria.

    Hi Nneakz

    You were right - the explanation did confuse. However the spreadsheet explains all.

    Here is one solution.

    Caution - it will only find the initials of the first occurrence, so any equal (ties) will not work.

    Regards
    Alastair
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 05-05-2013, 03:29 PM #3
    Nneakz
    Nneakz is offline
    Registered User
    Join Date
    05-05-2013
    Location
    Hertfordshire
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Copy adjacent cell data based on ranged criteria.

    Thank you SO much! Thats exactly what i need
    Reply With QuoteRegister To Reply
  4. 05-05-2013, 03:30 PM #4
    Lemice
    Lemice is offline
    Valued Forum Contributor Lemice's Avatar
    Join Date
    04-13-2013
    Location
    Somewhere.
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Copy adjacent cell data based on ranged criteria.

    Hello,

    You can try a simple INDEX MATCH, for example paste this formula in M2
    Please Login or Register  to view this content.
    And drag it down to M6.

    Similarly this one for O2 to O6
    Please Login or Register  to view this content.
    (copy pasta from Ford)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools

    Regards,
    Lem
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1