Using returned values as part of another formula

  • Thread starter Thread starter Duby
  • Start date Start date
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
 
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
 
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup and return sheet name also 2
With F1 value, look at A, if match or partial match return B 5
vlookup or index/match formula?? 2
Can a formula be "built" referencing text content from another cel 3
Making part of a formula a variable 1
Referring to a cell by using another cell for the row number 6
matching & combining data from seperate worksheets 2
How to Use two search criteria in one array. 2

Back
Top