I have a workbook with two tabs(worksheets) on it. The first contains a
copied 6 column database from an external source. In the second worksheet I
want to pull out a specific number from that database based on three
criteria. In English, what I want to say is:

In this Defined Range pinpoint the record that contains "East Division" in
column G, and "1" in column C and "521" in Column A. When you find that
record, show me what is in column D of that record.

Can you use lookup tables for more than one criteria? Is there something
else I can use that would work? Match? Index? Or is there a VBA formula I
can use. I am a little familair with VBA.