VLookup/Index to return multiple values

forum.ozgrid.com/index.php?attachment/55555/

In the attached excel, I am trying to return amount and regions column values associated with CID. Since Vlookup returns only the first instance of value encountered, I am unable to get other values associated with same CID.

Please can you help to correctly populate the other values for the same instance if CID.

Thanks in advance.

Re: VLookup/Index to return multiple values

Thanks Guys for helping out. Really appreciate it, I understand what you guys are suggesting. However, my problem is more dynamic though. To better understand the problem, I am uploading the original data sheet. If you see in this sheet, users enter NU ID, and depending on NU ID, it has to fetch data from "Data" tab. Now when they enter NU ID, there may be multiple values of Cinema ID, Amount and Forte, associated with that specific NU ID as I explained earlier. How can I make excel auto-update with corresponding values before they enter the new value of NU ID. For instance, when they enter NU ID "28286", it should update all corresponding values of Cinema ID, Amount and Forte for "28286", before going on to process next ID "28266".
Hope this clarifies the problem.

Thanks in advance for your help,

Hope you all have a great weekend as well.

Re: VLookup/Index to return multiple values

Hey Robert,

Yes. User will enter NU ID in Track tab, and it has to return Cinema ID, Amount, and Forte from Data tab. The output in the current tab is not correct as there are multiple value of Cinema ID, Amount, and Forte with NU ID 28286. I want all those values reflected before the user enters next NU ID i.e. 28266.

Hope this clarifies.

Thanks

Re: VLookup/Index to return multiple values

Robert,

He will be entering values in "Track Tab" in Column A (NU ID**).