Sorry, now I see I wasn't clear enough. Here are a few more details:
1. The number "4", or any other, is a constant that could either be entered
into a formula directly, or its value copied from a separate single cell,
2. The blocks of data extend down for hundreds or thousands of lines,
3. the array formula would be in a column inserted between cols A and B and
copied by dragging down the first entered cell.
4. importantly, by 'match & 4' I really meant MATCH values 'b' and '4' from
the same row, but in different columns'.

Hope this clarifies my question.

z.entropic

"Biff" wrote:

Hi!

Here are the formulas that will do what you want:

Entered with the key combo of CTRL,SHIFT,ENTER:

match a & 4, should give z

=INDEX(D1:D7,MATCH("A4",B1:B7&C1:C7,0))

match b & 4, should give m

=INDEX(D1:D7,MATCH("B4",B1:B7&C1:C7,0))

What these (and Bob's example) do is to concatenate the lookup values "A"
and "4" and to also concatenate the lookup range "B1" and "C1". It would
look like this:

Lookup value: A4

Lookup range:

A1
A2
A4

B1
B3
B4

However, I can't see a correlation with these formulas and where it appears
that you want to place the formulas.

Based on your posted sample, the formulas look like they are in cells E1 and
E5.

Biff

"z.entropic" wrote in message
...
A WS has names in col A and multiple blocks with the same name(s) with the
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