Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 387
  • Last Modified:

Match function not working

Hi,

I have attached a spreadsheet where there is a Match Function in H3 (YELLOW) that should return Check if there has been a change in the numbers between today and yesterday. As you can see from the SS there has been a change but the "Check" is not being returned.

Can anyone see why this is?

Thansk
Seamus
Example.xls
0
Seamus2626
Asked:
Seamus2626
2 Solutions
 
barry houdiniCommented:
Hello Seamus,

What constitutes a change?

Your MATCH function is only checking the first row with today's date, so it finds that in row 2 and there is no change so you get a blank, if you want check if there is any row with a change for today try

=IF(SUMPRODUCT((INT(E2:E1000)=TODAY())+0,(C2:C1000<>0)+(D2:D1000<>0)),"Check","")

regards, barry
0
 
RunriggerCommented:
Seamus, this part of the formula retruns row 2 - =MATCH(TODAY(),E:E,0)

Therefore this section --->>>
AND(INDEX(C:C,MATCH(TODAY(),E:E,0))=0,INDEX(D:D,MATCH(TODAY(),E:E,0))=0)

Returns AND(TRUE,TRUE), the result in the cell will therefore be ""
0
 
Seamus2626Author Commented:
Perfect Barry, thanks too Runrigger

Cheers
Seamus
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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