Reputation: 662
I'm trying to return column M when the date matches the date in column I. Any idea why it says N/A when I run the query function?
Here's the formula I'm trying to make work.
=QUERY(A2:M1000,"select M where(I='4/8/2016')")
Upvotes: 0
Views: 1614
Reputation: 18727
try:
=QUERY(A2:M1000,"select M where I=date '"&text(P1,"yyyy-MM-dd")&"'")
Upvotes: 2