Index, Match - HELP!

Hello, world! (ORIGINAL POST HERE)

I am trying to generate a formula, could be VBA or not, that would return multiple values. Basically, there are 4 tabs in the entire "tool" but the user only sees the first tab.

Tool (tab 1)

Zip (user entered data)
This row is merged, and has a purpose
KMA Populated via Vlookup
GLID Populated via Vlookup
Entity Populated via Vlookup

The problem is, sometimes there are multiple zip codes present - in this case the last 4 of the zip code is not always known so it is not used in this tool. I need a formula or VBA code that will return the values of A,B, C, D onto the tool tab, just below the actual tool itself, see below.

Data Sheet (tab 2)

* A B C D E
1 ZIP CODE KMA GLID Entity Count of Times ZIP appears
2 1515 * * * 1
3 1516 * * * 1
4 1517 * * * 3
5 1517 * * * 3
6 1517 * * * 3
7 1518 * * * 1
8 1519 * * * 1
9 1520 * * * 2
10 1520 * * * 2


Tool (tab 1)

Zip (user entered data)
*see below*
KMA Populated via Vlookup
GLID Populated via Vlookup
Entity Populated via Vlookup

*If the "count of zip" column (column E on data tab) returns a value of ">= 2", this row turns red with a simple text warning.

There is also a hidden table below this main tool that can be used to display the results of the 'values of A,B, C, D' on the data sheet, tab 2.


Here is my progress on this issue. I have this code on the tab 1 (tool), which is only pulling the first row, where I need it to pull from the same column, just the next one below. Any ideas?

{=INDEX(FINAL!$D$2:$D$3256, SMALL(IF($C$2=FINAL!$A$2:$A$3256, ROW(FINAL!$A$2:$A$3256)-MIN(ROW(FINAL!$A$2:$A$3256))+1, ""), COLUMN(FINAL!$A$2:$A$3256)))}

Let me be more specific. In this case, there are 9 instances of the zip code, '20153'. The only difference is they each have a different 'GLID'. I need to see each GLID this specific zip code references. See below, this should help.

GLID KMA ENTITY
GLID 1 * *
GLID 2 * *
GLID 3 * *
GLID 4 * *
GLID 5 * *
GLID 6 * *
GLID 7 * *
GLID 8 * *
GLID 9 * *

The * 's represent other data, that in this case did not change, but i need the same code for the GLID column to work on the other two columns too.

Welcome to the forums! Unfortunately, your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

Thank you for complying with the rules. You should do the same on the other forum in question.

Having read your query on both forums, I feel it would be useful to see your workbook.

Attach the workbook here. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thanks. Could you explain where you have mocked up the desired results? I'm not quite clear about what you are asking/trying to do.

Ah, I see - so what you are looking for really is a dependent drop-down list appear in C6 - is that it?

Glad you found your solution.