+ Reply to Thread
Results 1 to 3 of 3

Matching the number in one cell to the number in text string to return a value

  1. #1
    Registered User
    Join Date
    02-16-2011
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    2

    Matching the number in one cell to the number in text string to return a value

    Hello,
    I need to be able to match a number in cell I2 exactly to a number in cell D3 that is contained in a text string. If the match is true then the formula needs to return a value contained in cell H3. The problem is all the functions I have tried do not distinguish between similar numbers (for instance 34 and 344) so the results of these numbers are being duplicated in each of the relevant columns. The current formula I am using is:

    =IF((ISERROR((SEARCH(" "&I$2,$D3))))=TRUE,"",$H3)


    I have attached a jpg of a portion of my spreadsheet.

    Any help would be greatly appreciated.

    Kind regards
    Jane
    Attached Images Attached Images

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Matching the number in one cell to the number in text string to return a value

    Try

    =IF(ISERROR(SEARCH(" "&I$2&" "," "&$D3&" ")),"",$H3)

  3. #3
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Matching the number in one cell to the number in text string to return a value

    Try this one

    formula in K2

    =LOOKUP(10^308,SEARCH(" "&I2,D3),H3)

    Row\Col
    D
    E
    F
    G
    H
    I
    J
    K
    1
    2
    34
    -252.34
    3
    01613 Interest - Ned call 344
    -252.34
    4
    5
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ 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. Find a string withing cell range and return cell number
    By visak in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-16-2015, 09:19 PM
  2. Replies: 2
    Last Post: 10-04-2014, 03:50 AM
  3. [SOLVED] Return the first number in a text string
    By MarvinP in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-22-2014, 03:16 PM
  4. [SOLVED] Need to limit the number of decimal places of a number in a text string
    By Turbo Dog in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-11-2013, 07:47 PM
  5. [SOLVED] Return row number of text string
    By KimMorgan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-04-2013, 07:17 PM

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