# Index match from multiple worksheets based on dependent cell

1. ## Index match from multiple worksheets based on dependent cell

Hey all,

I have been looking through the forums, and found a few examples of this problem, but nothing I've been able to make work so far because of the dependent cell. I have three worksheets (Segment_1, Segment_2, Segment_3). Each worksheet has a set of unique IDs on them. I need to be able to look up the segment that has been selected on a fourth tab, and based on that value, pull all of the ID numbers and associated names.

I have attached a document and wrote an example of the problem on it. There is another problem included in the file as well that does something similar but the other way. Based on the multiple testing tabs, it looks up which ones contain the ID numbers and returns the average values.

Thanks,
B

2. ## Re: Index match from multiple worksheets based on dependent cell

This should achieve column B result.

Not sure what problem 2 is

Formula:
`Please Login or Register  to view this content.`

3. ## Re: Index match from multiple worksheets based on dependent cell

Hey Dave,

Thanks for the response. It would be a tough one to implement on my actual document because I have hundreds of "segments", so the If function would be a bit ridiculous. I ended up using this which seems to work:

=OFFSET(INDIRECT("'" & "Segment_" & \$C\$3 & "'!B8"), ROWS(\$B\$6:\$B6)-1, COLUMNS(\$B\$6:B\$6)-1)

Thanks again for the help though!

B

4. ## Re: Index match from multiple worksheets based on dependent cell

Originally Posted by BWellman
Hey Dave,

Thanks for the response. It would be a tough one to implement on my actual document because I have hundreds of "segments", so the If function would be a bit ridiculous. I ended up using this which seems to work:

=OFFSET(INDIRECT("'" & "Segment_" & \$C\$3 & "'!B8"), ROWS(\$B\$6:\$B6)-1, COLUMNS(\$B\$6:B\$6)-1)

Thanks again for the help though!

B
Good choice, I was looking at something for INDIRECT but with a small sample I opted against. Now knowing you have numerous options you've nailed it

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1