Hi, Sorry if this is basic, but I’m still learning.

This works – MIN(IF(Data!G:G=Answer!A2,(TIMEVALUE(Data!M:M))))

GG and A2 are names

This works – MIN(IF(Data!L:L=Answer!H1,(TIMEVALUE(Data!M:M)))

LL and H1 are dates

But when I combine them as follows it doesn’t – MIN(IF(AND(Data!L:L=Answer!H1,Data!G:G=Answer!A2),(TIMEVALUE(Data!M:M))))

Thoughts?

​Hi, Sorry if this is basic, but I’m still learning.This works – MIN(IF(Data!G:G=Answer!A2,(TIMEVALUE(Data!M:M))))GG and A2 are names This works – MIN(IF(Data!L:L=Answer!H1,(TIMEVALUE(Data!M:M)))LL and H1 are dates But when I combine them as follows it doesn’t – MIN(IF(AND(Data!L:L=Answer!H1,Data!G:G=Answer!A2),(TIMEVALUE(Data!M:M)))) Thoughts?  Read More

​