• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 54
  • Last Modified:

Excel: Match dates and return value

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
dabug80
Asked:
dabug80
1 Solution
 
Rgonzo1971Commented:
Hi,

Which values do you want to return for each date?

Regards
0
 
Saurabh Singh TeotiaCommented:
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
 
dabug80Author Commented:
Great. Works well
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now