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-04-2013, 10:10 AM #3
    excel_learner
    excel_learner is offline
    Member
    Join Date
    Apr 2011
    Posts
    69
    Rep Power
    15
    Thanks, however, this formula brings only the values if they are present in the range, if not it says N/A#. If I extend the date ranges in lookup formula then it works as it shows in attached sheet.

    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