=INDEX(Sheet2!C2:C20,MATCH(1,(Sheet2!A2:A20="A")*( Sheet2!B2:B20="a1"),0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"sahafi" wrote in message
...
I'm having some difficulties getting this done. I would like to lookup
values
in first two columns (category and sub category) in a range in a separate
table with 3 columns (match first two columns in first sheet to first two
columns in second table, and if both matches, return value in column 3 in
the
second table).
First sheet will contain data over 2000 rows, while the lookup table
contains a fixed 3 columns by 150 rows.

example:

Prod Sub Hours D | 1 2
3
|
A a1 120 | A
a1 2
A a2 180 | A
a2 1
B b1 140 | B
b1 4
B b1 160 | B
b1 4
C c1 200 | C
c1 3

Any help is greatly appreciated.
Thanks.

--
when u change the way u look @ things, the things u look at change.