Results 1 to 14 of 14

Look Up To Columns, if Match The Same Values Paste to Relevant Cell Values to Another Cell

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-16-2013
    Location
    World
    MS-Off Ver
    Excel 2007
    Posts
    215

    Question Look Up To Columns, if Match The Same Values Paste to Relevant Cell Values to Another Cell

    Dear all masters,
    I want to one suitable code. Read Entire "A" column and O Column,

    if matches same value,

    Paste to J, K column from Q,R columns Relevant Values.

    Example:

    Your code is reads Entire "A" Column, and reads one value as a "65",

    and now reads Entire O Column,

    And found same Value As a "65" at O3 Cell

    Now Take The Values From Q3 and R3

    And Paste to J3 and K3 ( i.e, 230 and 10)

    This is process for lookup and paste the values to target cells until end of "A" Column end page data, to J and K columns.

    Kindly Make the Good Macro code.

    Please find the Example file.

    Thanking You All.

    Best Regards,
    Prasad.
    Attached Files Attached Files
    Last edited by pvsvprasad; 08-10-2016 at 11:27 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Almost There! Match values in two columns and return text in adjacent cell
    By mrkake in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-01-2016, 02:14 AM
  2. Using Sumif() to find cell with match values in two columns
    By my2108 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-10-2015, 03:14 AM
  3. [SOLVED] Searching within a single cell and summing up relevant values
    By iambong in forum Excel General
    Replies: 6
    Last Post: 06-08-2015, 04:57 AM
  4. Replies: 7
    Last Post: 05-07-2015, 07:29 AM
  5. [SOLVED] How to compare two string in two different workbooks and Copy the relevant values & Paste?
    By somani123 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-13-2014, 06:47 AM
  6. Copy and Paste columns based on cell values
    By devin1428 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-17-2012, 07:50 AM
  7. Match value in one cell with values in multiple columns
    By sa02000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-08-2010, 05:12 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