Results 1 to 6 of 6

Lookup and Display of Matched Cell Data?

Threaded View

Nathanf Lookup and Display of Matched... 01-11-2012, 12:49 AM
JBeaucaire Re: Lookup and Display of... 01-11-2012, 01:28 AM
Nathanf Re: Lookup and Display of... 01-11-2012, 05:26 AM
bebo021999 Re: Lookup and Display of... 01-11-2012, 05:31 AM
Nathanf Re: Lookup and Display of... 01-11-2012, 06:47 AM
JBeaucaire Re: Lookup and Display of... 01-11-2012, 05:35 AM
  1. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,645

    Re: Lookup and Display of Matched Cell Data?

    Supposed your dates are in A1:A365, amount in B1:B365, your seach amount in E2, return date in F2.
    In F2:
    =MATCH($E$2,$B$1:$B$365,-1)+IF($E$2>=AVERAGE(INDEX($B$1:$B$365,MATCH($E$2,$B$1:$B$365,-1)),INDEX($B$1:$B$365,MATCH($E$2,$B$1:$B$365,-1)+1)),0,1)
    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