Results 1 to 2 of 2

Thread: Lookup Formula

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 02-01-2012, 01:38 PM #1
    excel_learner
    excel_learner is offline
    Member
    Join Date
    Apr 2011
    Posts
    69
    Rep Power
    15

    Lookup Formula

    I am using lookup formula for values in range to get the desired value for a lookup value, however, lookup formula fetches the value if it falls in range and if the value is not in the lookup range i want to put else condition.

    I have attached the file for easy reference.

    Kind assist ASAP.
    Attached Files Attached Files
    ----
    excel_learner
    (Using XL 2007 & 2010)

    -------Learning never stops!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Lookup Picture Using Formula Without Using VBA
    By paul_pearson in forum Excel Help
    Replies: 16
    Last Post: 11-06-2013, 01:28 PM
  2. Lookup Picture Using Formula Without Using VBA
    By mahmoud-lee in forum Excel Help
    Replies: 3
    Last Post: 06-13-2013, 06:53 PM
  3. Lookup Formula Not Erroring Out When Value Not Found Looking Up Approximate Value
    By excel_learner in forum Excel Help
    Replies: 5
    Last Post: 06-04-2013, 01:04 PM
  4. Use Native Excel Function Lookup Formula In VBA
    By ramananhrm in forum Excel Help
    Replies: 8
    Last Post: 05-03-2013, 09:10 AM
  5. Lookup All Corresponding Values Match Criteria In Adjacent Column Array Formula
    By d380013 in forum Excel Help
    Replies: 16
    Last Post: 04-19-2013, 08:20 PM

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
  •  

Forum Rules