Results 1 to 6 of 6

Thread: Lookup Formula Not Erroring Out When Value Not Found Looking Up Approximate Value

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 06-03-2013, 04:48 PM #1
    excel_learner
    excel_learner is offline
    Member
    Join Date
    Apr 2011
    Posts
    69
    Rep Power
    14

    Lookup Formula Not Erroring Out When Value Not Found Looking Up Approximate Value

    I have dates ranges (not all months individually) e.g 01/07/2010 - 30/06/2011, while applying lookup formula I get the last value while looking up for a date within the range even if the date is not within the range. I have attached the sample sheet for easy reference.

    Thanks
    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 Value and Concatenate All Found Results
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 48
    Last Post: 10-31-2019, 07:00 AM
  2. Lookup Picture Using Formula Without Using VBA
    By paul_pearson in forum Excel Help
    Replies: 16
    Last Post: 11-06-2013, 01:28 PM
  3. Lookup Picture Using Formula Without Using VBA
    By mahmoud-lee in forum Excel Help
    Replies: 3
    Last Post: 06-13-2013, 06:53 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 Formula
    By excel_learner in forum Excel Help
    Replies: 1
    Last Post: 02-01-2012, 03:08 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