I have two separate spreadsheets.
One is a calendar for my department in a ships agency company, which is where the data must go, and the other is a list of ships that are calling our harbour.
Both are in sorted into rows, with the columns being headers. Thus the agents (myself and my colleagues) have a column each and the date is the first column.
There can be several ships in port on the same date.
I want to put in the ships name in the calendar for all agents.
As I see it, this requires a formula to check the date and then to check if that specific agent have any ships on that day. All agents are identified by a 3-letter code.