Results 1 to 22 of 22

find text match amount and paste from sheet1 to sheet2

Threaded View

  1. #1
    Forum Contributor visha_1984's Avatar
    Join Date
    11-27-2012
    Location
    Pune,India
    MS-Off Ver
    Excel 2013
    Posts
    309

    find text match amount and paste from sheet1 to sheet2

    Hi Team,

    I have tried vlookup for col "F" but i didnot get output which i want.
    here we go what i want
    1) Copy party name from col "E" sheet1 and find in col "F" sheet2 ,after that
    2) match amount in col "D" sheet1 with col "L" sheet2 and paste CODE from sheet1 to col "M" in sheet2
    3) If amount not match leave blank or AMOUNT NOT MATCH ,then repeat step - 1,2
    4) If party name not found in sheet2 try next party.

    I also tried pivot and vlookup but amount could not matched,Is there any formula or VBA code to do this
    I have attached sample workbook.

    Any help would be much appreciated.
    Visha
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 07-25-2013, 02:58 PM
  2. Replies: 2
    Last Post: 04-28-2013, 02:23 AM
  3. How to match Date and Amount from Sheet1 to Sheet2 with the same Date and Amount?
    By ims0phie in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-23-2013, 06:51 AM
  4. [SOLVED] Copy and Paste Entire Row from Sheet1->Sheet2 based on text string match in Sheet1 Row
    By dmlovic in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-17-2012, 08:42 AM
  5. Searching Sheet2 to find a match on Sheet1
    By ca1358 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2011, 02:05 AM

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