Hi!

formula doesn't work

What does that mean? No value being returned? Incorrect value being
returned? An error being returned?

There's nothing wrong with the syntax of either formula, so, as long as the
ranges are correct and the lookup values exsist they should return the
correct values.

Biff

"Duby" wrote in message
...
In cell A7 i have the following formula: =INDEX(JOB_DATA,MATCH(I7,'Job
Data'!A2:A140,0),2)
It returns the name of a customer from my named list Job Data (which is
also the name of the worksheet) based on a number that I enter into cell
I7.
I would like to use the resulting name of that customer as the match
criteria in another formula.
Something like =INDEX(CUSTOMER_DATA,MATCH(A7,'Customer Data'!A2:A83,0),2)
but his formula doesn't work. Any suggestions?
Scott