Results 1 to 7 of 7

conditional vlookup

Threaded View

  1. #1
    Registered User
    Join Date
    04-03-2005
    Posts
    58

    conditional vlookup

    I am looking to have a conditional look up. Sample file is attached here.

    I have three sheets in the file. Sheet 1 is where i want to capture last purchase date of an item code, which will be taken from sheet 2008 first, if not available for that item, then it will go to sheet 2007. If it is not available in both of the sheets, then I want the cell to be displayed with "-" & not "#N/A".
    In the last column I want to calculate the number of days from last purchase date to 31-12-08.

    thanks in advance
    Attached Files Attached Files

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