I have 2 different ways I am trying to bring some date in from another sheet. Both are giving me unparseable error messages. I can’t seem to see what the issue is. Here are the 2 formulas I have tried.
=INDEX({Location},"1655 W Jackson",MAX({Audit Date},{Waxie DBBC Disinfectant}@row))
Or
=IF({Location},"1655 W Jackson",MAX({Audit Date},{Waxie DBBC Disinfectant}@row))
the goal is to look at the location column and select a specific location and then look at the Audit Date field and find the max date that coincides with the location and then pull in the data in the Waxie DBBC Disinfectant field @ row.
New contributor
Deborah Mayers is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2