Matching Various Columns & Importing

[amagee]

Hello,

I have two files, each contains a list of classes from a different source. I want to match the information on 4 criteria (column A - Course, column B - Day, Column C - Start Time, Column D - End Time), and then if those 4 criteria match import Room Information (Column E in File B) into File A.

I hope that makes sense.
Any thoughts?

[mehmetcik]

Can I see samples of each file and your required output?

[amagee]

Sure thing.

[amagee]

So if Column A, B, C & D match exactly in both Sample A & Sample B, than I need Column E from Sample B to be imported into Column F of Sample A.