Yes it is possible

=INDEX(D1:D500,MATCH(1,(G1:G500="East Division")*(C1:C500=1)*(A1:A500=521),0))

entered with ctrl + shift & enter

If you want to use a defined name it becomes a bit ltrickier
Assume the table is named MyTable and holds the range
A1:G500

=INDEX(MyTable,MATCH(1,(INDEX(MyTable,,7)="East
Division")*(INDEX(MyTable,,3)=1)*(INDEX(MyTable,,1 )=521),0),4)

also array entered


Regards,

Peo Sjoblom


"JICDB" wrote:

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.