Get excel data by two conditions

May 13, 2009 at 02:07:52
Specs: Windows XP

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.

Any ideas?

See More: Get excel data by two conditions

Report •

May 13, 2009 at 06:58:20
I, for one, need a little clearer explanation of the layout of both sheets before I could suggest anything.

Report •

May 13, 2009 at 07:58:28
I took a snap of the two files lined up over eachother and uploaded to imageshack:

All help is Greatly appreciated!

Report •

May 13, 2009 at 12:19:09
imageshack is blocked by my corporate security system.

I'll take a look when I get home tonight.

Report •

Related Solutions

Ask Question