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