Hi Phyllis

What does Job_CodeB refer to when you go to insert / name / define and click
on it?
same question for
Job_CodeA&union_local&Rate_Code

Cheers
JulieD

"Phyllis" wrote in message
...
I'm going to try this one more time. As I keep working
I'm find some of the answers to my questions, however
there's one I just can't figure out. Here's what I have
now:

Sheet Name: Active
I Q U
Union Local Job CodeA Rate Code

Sheet Name: Job Codes
A B C J
Union Local Job CodeA JobCodeB Rate Code

Here the formula that I'm trying to put into the sheet
named Active

{=INDEX(Job_CodeB,MATCH(Active!Q1&Active!I1&Active !
U1,Job_CodeA&union_local&Rate_Code,1))}

This returns JobCodeB that matches JobCodeA, Union Local
and Rate code. The formula works fine for the first 28
rows, then it stops. What am I doing wrong?