+ Reply to Thread
Results 1 to 7 of 7

Input 3 numbers a cell and output in another cell based on the numbers entered

  1. #1
    Registered User
    Join Date
    01-02-2021
    Location
    United States
    MS-Off Ver
    office 365
    Posts
    17

    Input 3 numbers a cell and output in another cell based on the numbers entered

    Any help will be greatly appreciated.

    I am looking input 3 numbers a cell and receive and output in another cell based on the numbers that I inputted in the cell. Below is my example.


    input is 123 or 213 or 321 output = ABC

    or

    if the input is 223 or 221 or 224 output = AAB.



    Thank you.
    Last edited by AliGW; 02-08-2022 at 01:54 PM. Reason: Title changed - please think more carefully about your thread titles in future!

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: Input 3 numbers a cell and output in another cell based on the numbers entered

    Administrative Note:

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. As you are still quite new here, I have done it for you this time.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Input 3 numbers a cell and output in another cell based on the numbers entered

    ??

    =VLOOKUP(A1,G:H,2,FALSE)

    see file.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Input 3 numbers a cell and output in another cell based on the numbers entered

    I've just noticed your title. It's pretty weak.

    A GOOD thread title is the sort of thing you would use as a search term on Google*. Your chosen title would produce a squillion useless hits. In future, please take a bit more time to think of a descriptive title that would be "Google-friendly". Many people search the forum answers looking for help and your very general title wouldn't help them at all.

    Since I've already replied, on this occasion, I will change it for you.

    However, if you continue to use weak titles, you can expect to have your thread BLOCKED until you change it yourself. If that happens, to edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.

    *Other search engines are available!!!

    Regards,

    Glenn.

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Input 3 numbers a cell and output in another cell based on the numbers entered

    Meh! Ali has changed it already.

  6. #6
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,177

    Re: Input 3 numbers a cell and output in another cell based on the numbers entered

    in a sheet say sheet2, enter your list at A1,A2:
    123, ABC
    213, ABC
    321, ABC
    223, AAB
    221, AAB
    224, AAB

    then in sheet 1, col A1
    enter 123
    the formula for B1 would be like:
    =VLOOKUP(Sheet1!A1,Sheet2!A1:B6,2)

    =VLOOKUP([cell with value to find], [matrix array of all values to lookup],[column to return])

  7. #7
    Forum Expert
    Join Date
    10-11-2021
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    1,386

    Re: Input 3 numbers a cell and output in another cell based on the numbers entered

    You miss a parameter, an important one

+ 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. Reconcile output vs input
    By HerAngel in forum Excel General
    Replies: 3
    Last Post: 05-10-2020, 09:11 AM
  2. input number and output name
    By thomas87 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-31-2016, 08:26 PM
  3. Need output for below input query
    By satyendra21 in forum Excel General
    Replies: 2
    Last Post: 11-17-2015, 06:51 AM
  4. Formulae Input/output help please
    By bimo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-03-2014, 02:52 PM
  5. [SOLVED] Transferring of input from input cell to output cells
    By bebongtheshark in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-09-2014, 01:28 AM
  6. [SOLVED] input dob / input certain age / output date at certain age
    By Alastair77 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-12-2014, 09:36 AM
  7. Input to Output
    By Rural Nutty in forum Excel General
    Replies: 4
    Last Post: 08-12-2008, 11:17 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