I guess I wasn't clear about the setup. This was only a sample of data from a
larger table that is only the source of the data and not the destination. The
destination is a cell on another worksheet that has adjacent cells with the
selection criteria (values that I want to find) in them.

Where A1 and B1 on the destination sheet = A1 and B1 on the table, return
the value from D1 to this cell


"Jacob Skaria" wrote:

If it is a unique list use

=SUMPRODUCT(--(A2:A6="ALB"),--(B2:B6="SLWA"),--(D2:D6))

If this post helps click Yes
---------------
Jacob Skaria


"Picman" wrote:

I have a table that i want to extract data from one column based on 2
conditions in other columns. The table has 4 columns, the first and second
are the columns that contain the data that has to meet the conditions, and
the fourth has the data the I want to retrieve. See below.

COMRAT SALREP COMRATDES COMPER1
ALB SL1D ABC Co. 4
AP SLA1 DEF Co. 6
ALB SLWA GHI Co. 2
AJ SL1G JKL Co. 7
ALB SL1H MNO Co. 10

Both the value in column A and the value in column B must match the
corresponding values from another worksheet and then return data from the
forth column. Example of a condition might be Column A=ALB and Column B=SLWA
then return 2.
I'm thinking that an index and match might be the way to go, but i need a
little help getting there.