Results 1 to 4 of 4

Selecting values from adjacent rows

Threaded View

  1. #1
    Registered User
    Join Date
    10-14-2009
    Location
    Pretoria, South Africa
    MS-Off Ver
    Excel 2003
    Posts
    3

    Selecting values from adjacent rows

    Hi,

    I have 2 rows:
    Row1: each column has the date (e.g. dd/mm)
    Row2: each column has a numeric value e.g. 272)

    I want to in another cell do the following.

    a. Search Row1 to find a date equal to todays date.
    b. Then select the matching value from Row2 and place that in my cell.
    or if it cant find todays date then it should take the value from the previous cell (date).

    ie. Row1: 04/11 05/11 06/11 07/11 09/11
    Row2: 345 340 335 320 305

    If todays 06/11 then it must return 335 to my cell. If today is 08/11 it must return 320 into my cell.

    Please assist with this comulation.

    Thanks
    Last edited by illinge; 11-05-2009 at 06:37 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