Something like this maybe?

=INDEX(D:D,SUMPRODUCT(--($A$2:$A$4=E2),--($B$2:$B$4<=F2),--($C$2:$C$4=F2),ROW($A$2:$A$4)))

formula evaluates to 0 if no result is found. Could encase this formula in
an IF function if "N/A" output is necessary.

--
Best Regards,

Luke M
"Richard Radcliffe" <Richard wrote in
message ...
I have an array with 4 columns:

A B C D
1 435 578 ID1
2 12 113 ID2
3 1478 1879 ID3
etc etc etc etc

The value I want to lookup has two components that correspond to column A
and a number that falls between columns B and C (or not):

E F
1 78
2 86
2 1500
3 1600
etc etc

So I'd like to ask is the value in column E = to the value in column A AND
does the value in column F fall between the values in columns B and C? If
yes, return column D.

In this example, I would get back:
#N/A
ID2
#N/A
ID3
etc

I hope I've explained this well.

Thanks in advance,
Richard