+ Reply to Thread
Results 1 to 2 of 2

Searching and displaying values

  1. #1
    Registered User
    Join Date
    07-08-2011
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    1

    Searching and displaying values

    Hi there,

    If I have the following values:

    1 a
    2 b
    ___c (i could not show spaces)
    3 d
    4 e
    5 f


    If I entered a number it will search the corresponding letter. In the number 2 I would like to show only b or c if a previous statement was true.

    The question is, how can i get the b or c values?

    If it was only one line per letter, i could use vlookup function, but in the cases that there are multiple values in a number I don't know how can i get it.


    Thank you

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Searching and displaying values

    please post a workbook if you expect a formula suggestion.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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