+ Reply to Thread
Results 1 to 2 of 2

Need help with excel function formula

  1. #1
    Registered User
    Join Date
    12-20-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    1

    Need help with excel function formula

    Hi guys, really need your help,

    Lets say i have a text in a cell from
    The text that i have is

    A1,A2,A3,A4
    B1,B2,B3,B4,B5,B6,B7,B8,B9,B10
    C1,C2,C3,C4,C5,C6,C7
    D1,D2
    (these are all text's not the cell number)


    is there anyway i can use a formula like 'if ' or vlookup that helps me
    when the text is from A1 to A4, then "A" will come out on another cell, if B1 to B10, then come out B, if C1 to C7, come out C, if D1 to D2 then come out D.

    example, if cell D6 contains text "A1", then it will come out , on another cell.
    and if cell D6 contains text "D2" it will comeout D on another cell.

    i keep trying to figure out using the if function, but I can't think of the formula.
    Any help would be really greatly appreciated.
    Last edited by nstoner; 12-20-2012 at 11:09 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,306

    Re: Need help with excel function formula

    nstoner, welcome to the forum

    however, please rename your thread to something more meaningful, that actually describes your problem. lots of contributors will look at a thread title, and if it is of interest to them, or falls within their area of expertese, they might only open those threads. also, searching for "help" will not turn up too many results that will benifit you, sorry.
    To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title"
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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