VLookup/Index to return multiple values

  • Re: VLookup/Index to return multiple values


    If you are able to use a helper column in your data tab you can use the attachment


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


    It will handle up to 9 instances of a CID you type into column A of TAB A.


    You need to copy down the helper column formula to match the range of your data, and you can copy down and across the formulas used on TAB A to suit your needs.


    Cheers,
    Dan

  • 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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!