Vlookup multiple terms and return one value
Thanks Bob. It worked, but how do I copy the formula down? do I need to
change from relative to absolute, or is there a tricky way of doing this?
Thanks.
--
when u change the way u look @ things, the things u look at change.
"Bob Phillips" wrote:
=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.
|