Using returned values as part of another formula

D

Duby

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
 
B

Biff

Hi!
formula doesn't work
Click to expand...

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
 
D

Duby

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
 
D

Duby

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.
 
Top