Results 1 to 11 of 11

Vlookup 2 values (looking for approximate values)

Threaded View

  1. #1
    Registered User
    Join Date
    03-05-2009
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    11

    Vlookup 2 values (looking for approximate values)

    I am trying to do a vlookup function of 2 values but the key lookup column is an approximation.

    I have attached a sample data file. Essentially, on Sheet 1 Column M (labeled as EPS), I want to do a vlookup of both Column A and B, and copy the values in Sheet 2 Column K into Column M. The approximate value comes from Column B, the date, as Sheet 1 has all the dates from 2001 and 2008 while Sheet 2 only has 4 dates per year. On sheet 2, the first 2 dates are 10/30/2001 and 2/5/2002. I want the EPS value for 10/30/2001 to stand for all values between 10/30/2001 and 2/5/2002.

    The Vlookup function with a True value for the last criterion can do this for a vlookup of 1 variable, but it doesn't work for 2. Can someone please help?


    Thanks
    Kevin
    Attached Files Attached Files
    Last edited by tianyi86; 03-05-2009 at 01:13 AM.

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