G

#### Guest

corresponding values in subsequent cols. Here is an example

A B C D

------------

1 a a 1 x match a & 4, should give z

2 b a 2 y

3 c a 4 z

4

5 d b 1 k match b & 4, should give m

6 e b 3 l

7 f b 4 m

(the value 4 in col C is the second condition to be matched).

For each value in col A, I'd like to find values in col D _IF_ the values in

cols B and C also match my conditions.

I've tried to build INDEX/MATCH/* formulas, but so far with little success

as the dual syntax of INDEX is 'a bit' confusing. Chip Pearson's Lookups page

was helpful, but did not have such a case. Bob Phillips' formula, while

relevant, is inscrutable to me:

"If by chance you mean a double lookup, where you have 2 key columns and you

want to match both and get the adjacent value in another column, you can use

=INDEX(C1:C100, MATCH(D1&D2,A1:A100&B1:B100,0))"--what is what here?

z.entropic