Results 1 to 2 of 2

Lookup problem when selecting zero

Threaded View

  1. #1
    Registered User
    Join Date
    01-23-2014
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    3

    Smile Lookup problem when selecting zero

    My lookup does not show the required results when select a zero value.

    Basically I need 3 values (deposit Value) that returns 3 different conditions.

    The Deposit values need to be a value as I need to work out the deposit in another part of the spreadsheet.

    I have attached a sample which replicates the error.

    Any help is appreciated to resolve this.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Selecting last row problem
    By siobeh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-23-2014, 02:40 PM
  2. [SOLVED] Selecting different ranges for a lookup
    By virsilens in forum Excel General
    Replies: 3
    Last Post: 12-06-2013, 04:19 PM
  3. [SOLVED] Selecting range problem
    By dorre in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2006, 10:40 PM
  4. [SOLVED] selecting a cell based on lookup with VBA
    By PhilipsBernard in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2005, 09:05 AM
  5. VBA problem selecting column
    By bbertran in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-06-2005, 01:33 PM

Tags for this Thread

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