Using returned values as part of another formula
 

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

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

The value being returned is 0.
I am wanting it to look at the cutomer data page and return the address for
the customer name being returned in A7
Scott

"Biff" wrote in message
...
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

Nevermind Biff, I just figured it out. I had the named list including my
header row and it was throwing everything off by one row and the row
underneath had no data in that cell. Thanks.
"Duby" wrote in message
...
The value being returned is 0.
I am wanting it to look at the cutomer data page and return the address
for the customer name being returned in A7
Scott

"Biff" wrote in message
...
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