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

Threaded View

  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

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