Results 1 to 12 of 12

VBA to lookup for a specific value and give result

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-13-2014
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    140

    VBA to lookup for a specific value and give result

    I Have a workbook with 2 sheets " Acct. Details" and "Manual Checking"
    In sheet "Manual Checking" have a column F (UTR NO.2) which contains digits.

    Check the same digits in Sheet "Acct. Details" in column C (Particulars).
    If string in C of Sheet "Acct. Details" contains the Digits of Column F of Sheet "Manual Checking" then in column "I" in "Manual Checking" should show SR. no. (Column D) from Acct Details.
    If the digits are not exists the result should be "No Sr."

    For example please refer sheet "Result Needed". Required result marked in grey colour
    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. Need Formula to lookup for specific text in a string and give desired output.
    By winmaxservices1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-18-2014, 03:45 PM
  2. Lookup and place result in specific cell
    By kjones600 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-09-2014, 12:46 AM
  3. [SOLVED] Lookup multiple criteria in table and give row + culmn as result
    By bidsinga in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-02-2014, 03:40 PM
  4. need a lookup formula to return a specific result...
    By tsiguy96 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-15-2013, 08:40 AM
  5. [SOLVED] i have multiple lookup in my excel, its give result "0" i want blank outpu.
    By vengatvj in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-25-2013, 02:05 PM
  6. Replies: 1
    Last Post: 09-17-2012, 09:35 AM
  7. Lookup/Find Sheet then give value of specific cell within sheet
    By DoriBeE in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2011, 08:42 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