+ Reply to Thread
Results 1 to 4 of 4

Returning Multiples Values in a a cell using IF function

  1. #1
    Registered User
    Join Date
    08-16-2017
    Location
    Kuala Lumper,Malaysia
    MS-Off Ver
    2016
    Posts
    2

    Returning Multiples Values in a a cell using IF function

    Hi Guys,
    I am new to excel and i need some help on a file i'm working on. I need to know if there is a way i can use IF functions to return multiples values in a cell. I have attached a sample document. I would really appreciate some assistance on this.
    Attached Files Attached Files

  2. #2
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Returning Multiples Values in a a cell using IF function

    Hi aang, welcome to the forum! This formula inserts a space after each month to provide visual separation. Paste in Z3 and copy down:
    Please Login or Register  to view this content.
    Hope it helps- Lee

    Please click the Add Reputation star below any helpful posts, and use Thread Tools (up top) to mark your thread as SOLVED once you have your answer. Thanks!-Lee
    Last edited by leelnich; 08-17-2017 at 02:12 AM.

  3. #3
    Registered User
    Join Date
    08-16-2017
    Location
    Kuala Lumper,Malaysia
    MS-Off Ver
    2016
    Posts
    2

    Re: Returning Multiples Values in a a cell using IF function

    Hi Lee,
    It worked.
    thank you very much for your assistance. I really appreciate it.

  4. #4
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Returning Multiples Values in a a cell using IF function

    No problem, happy to help. Take care, and thanks for the rep! -Lee

+ 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. [SOLVED] Searching for multiples and returning a name
    By vbcoachwasi in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-10-2017, 12:38 AM
  2. Returning Multiples Values with a Lookup using Index Array
    By NEEDEXCELHELP123456 in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 11-04-2014, 10:16 AM
  3. Returning Four Different Values For an IF Function
    By WSJ in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-24-2014, 05:16 PM
  4. [SOLVED] Need Index and Match to return multiples values in the same cell
    By ludi in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-16-2013, 10:50 AM
  5. Look up function returning rogue values :-(
    By Pingbat in forum Excel General
    Replies: 4
    Last Post: 04-30-2013, 10:57 AM
  6. [SOLVED] Counting Multiples Values in one cell
    By ROB40160 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2012, 09:28 AM
  7. VLookup returning same data when multiples exist
    By Laserfast in forum Excel General
    Replies: 8
    Last Post: 05-12-2011, 12:56 PM

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