How to modifyVLOOKUP,to show a lookup value with several different values from table array

Hi Arty,

The Vlookup modification I use is to Vlookup itself until its frequency is achieved then it Vlooksup the next item, row cell by using a LINK to next and so on until the Total Sum is achieved. The data result for each entry is given by using Index & Match. I wrote it on an earlier version of xcl here it is, the solution in green background, input data in blue. 4 additional columns are needed though. I used Arty example #5. I added an extra AA so you can see better how it works. Let me know what you think & if we can fudge together the additional columns somehow.

My best regards
Paul