Nevermind. I figured it out. Thanks a bunch.

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


"sahafi" wrote:

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.