TABLE A
LOC Date SVC
100 11/1/93 384
100 11/1/93 476
100 11/1/93 491
100 11/1/93 647
100 11/1/93 711
100 1/1/93 885

TABLE B
DATE SVC Start# SVC END# LOC SEC type form
9/1/91 1454 852351 100 27 25 5-8
9/1/91 857911 2699852 100 27 25 8-16
9/1/91 4800881 4964811 100 45 42 6
4/1/92 577 332922 100 28 32 1-4
4/1/92 335898 468922 100 28 32 4-5
4/1/92 4681038 760298 100 28 32 5-8
4/1/92 760945 938883 100 28 32 8-10
4/1/92 939708 1131800 100 28 32 10-12
4/1/92 1133852 1258391 100 28 32 12-13

I need to look up data in table 1 and if date matches table 2 and SVC falls
within a given range in start and end svc in table 2 - copy SEC,TYPE and
FORM.(these columns are in txt format)..
I used INDEX(TABLE2,MATCH(DAte,DATE(TABLE2),0),MATCH(SVC< = START
SVC,0),MATCH(SVC=END SVC#,0) but this does not work.

--
mmk