+ Reply to Thread
Results 1 to 1 of 1

How to formulate lookup function?

  1. #1
    Registered User
    Join Date
    06-18-2010
    Location
    Hong Kong
    MS-Off Ver
    Excel 2007
    Posts
    1

    How to formulate lookup function?

    I'm an excel newbie and I need a lookup formula that will return data on my cells.

    I have a Data in columns A and B (about 45,000 rows)

    Column A Header = Campaign
    Column B Header = Date

    my criteria in F52, and based on this criteria I need to return the previous date in F55 and the next 2 previous date in F56.

    I attached a dummy workbook for reference.

    Thanks!
    Attached Files Attached Files

+ Reply to Thread

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