+ Reply to Thread
Results 1 to 2 of 2

Simple Lookup formula

  1. #1
    Registered User
    Join Date
    11-18-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2011
    Posts
    54

    Question Simple Lookup formula

    hi, would anyone know now to simply from a list of digits,
    find (label "y") of the specific criteria of a input value say 3 in (C1)

    example:
    if C1 = 3

    A1 B1
    1
    2
    3 "y"


    PS the lookup sample range always looks back from its current last position (not start position).

  2. #2
    Forum Contributor
    Join Date
    09-27-2012
    Location
    London, England
    MS-Off Ver
    2003, 2010
    Posts
    344

    Re: Simple Lookup formula

    Hi Stews, you may need to provide more details as your requirements are not clear from above. Would be helpful if you could upload a sample workbook.

    Thxs.
    If solved kindly remember to mark Thread as solved.
    Click the small star icon at the bottom left of my post if this was useful.

+ 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