+ Reply to Thread
Results 1 to 5 of 5

Find a number in a List and return Outcome, but number is in a long string within the cell

  1. #1
    Registered User
    Join Date
    10-23-2014
    Location
    USA
    MS-Off Ver
    Newest
    Posts
    7

    Question Find a number in a List and return Outcome, but number is in a long string within the cell

    I spent all day getting to this point with personnel logs and am stuck.

    Cell B3 has "Davis, Jeffery B XX-13 ABCD 325 ERT/YUT"

    A list from C3 down to C10 has options 1,2,3,4,5,324,325,326
    A list from D3 down to D10 has options a,b,c,d,e,f,g,h

    I'm trying to get cell A3 to be populated with the letter G since "325" is in cell B3, 325 is in cell C9, and the letter G is in cell D9.
    Attached Files Attached Files

  2. #2
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,410

    Re: Find a number in a List and return Outcome, but number is in a long string within the

    Please try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-23-2014
    Location
    USA
    MS-Off Ver
    Newest
    Posts
    7

    Re: Find a number in a List and return Outcome, but number is in a long string within the

    Quote Originally Posted by HansDouwe View Post
    Please try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    It works perfectly! All hail Hans. Thank you so much.

  4. #4
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,410

    Re: Find a number in a List and return Outcome, but number is in a long string within the

    Thx for the feedback.
    Good to hear that the formula works the way you want it to.

    You may also consider adding reputation to the answers of all helpers that you think are worth the answer.
    This can be done by clicking on * Add reputation at the bottom left of the answer

  5. #5
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,410

    Re: Find a number in a List and return Outcome, but number is in a long string within the

    Thx for the rep .

+ 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 first >= number in a list and return that number in a spill range
    By Coley356 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-16-2021, 03:59 PM
  2. Return Specific Number from Number Text String
    By BEEROG in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-29-2020, 01:43 PM
  3. [SOLVED] Help with formula to return a number based on number string
    By maym in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-10-2017, 11:45 PM
  4. 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
  5. Replies: 2
    Last Post: 01-28-2015, 09:07 AM
  6. if statement to find a number and return that number in a cell
    By Neelam82 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-08-2013, 10:22 PM
  7. Replies: 6
    Last Post: 01-13-2010, 10:26 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