+ Reply to Thread
Results 1 to 2 of 2

Matching and searching

  1. #1
    Registered User
    Join Date
    11-25-2020
    Location
    india
    MS-Off Ver
    2007
    Posts
    1

    Matching and searching

    I need a formula to look at a history of transactions and find out who the transaction is really from. open the thread to find the attached file


    i have 10's of thousands of rows like this
    If i get a new transaction id like UPI 032514654 SHANGAM SBIN SHANGAM and the amount of Rs.35000
    I want it to be able to read the history of transactions and give me a list of the possible parties based on the the character string in the transaction id and if the amount is withing a + 0r - 40% range.
    Attached Files Attached Files
    Last edited by Gokulmaclarenp1; 11-26-2020 at 06:19 AM.

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,772

    Re: Matching and searching

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

+ 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] Help with searching/matching with formula
    By CRBV in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-23-2020, 03:06 PM
  2. [SOLVED] Word searching and matching
    By Potholes in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-01-2020, 05:00 AM
  3. problem with searching and matching
    By tianshu in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-03-2016, 06:34 PM
  4. Replies: 11
    Last Post: 05-16-2012, 01:42 PM
  5. Searching and Matching
    By Salient in forum Excel General
    Replies: 3
    Last Post: 06-30-2009, 11:49 AM
  6. [SOLVED] Searching and Matching Lists
    By sylink in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-16-2006, 12:00 PM
  7. Searching for a particlar value and matching to a name..
    By spezialize in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-08-2005, 09:15 PM

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