Solved

Excel: Match dates and return value

Posted on 2015-02-23
3
49 Views
Last Modified: 2015-02-26
Hi,

Attached is a sample spreadsheet. As written on the sheet - I would like help with the formula for the yellow cells. I am looking to match 2 date values, then return a cell value above the second date value.

Can you please help.

ee-Factory-no4.xls
0
Comment
Question by:dabug80
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 50

Expert Comment

by:Rgonzo1971
ID: 40627542
Hi,

Which values do you want to return for each date?

Regards
0
 
LVL 59

Accepted Solution

by:
Saurabh Singh Teotia earned 500 total points
ID: 40627598
For getting the status for that dates you can use the following formula...

=IFERROR(INDEX($B$2:$E$2,1,MATCH(I7,$B$3:$E$3,0)),"")

Open in new window


Enclosed is your worksheet...

Saurabh..
ee-Factory-no4.xls
0
 
LVL 1

Author Closing Comment

by:dabug80
ID: 40634559
Great. Works well
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question