Index, Match and Concatenate

Hello Forum!

Well my boss likes the report, but he now has a "However". He decided he wants mulitiple document numbers displayed on the roll-up screen. I have received wonderful assistance in creating the formula below.

I have attached the design document for what is needed.

Background: There are two sheets, ABF_Records and DOCNO. The ABF_Records is a roll up of the ON HAND BALACE for a stock number in a warehouse. The DOCNO an Excess Report list showing all the excess by specific condition code, quantity reported and a unique document number. Both are generated by scripts used to pull the raw data into a .csv file, and we have used them independently. Now, there is a need to pull the document numbers from the DOCNO into the ABF_Records Column A. The below script works pulling single document numbers, but doesn't pull multiple document numbers in Column A (ABF_Records).

IF(DOCNO!$F$3=""|""|INDEX(DOCNO!F$3:R$5000|MATCH(1|INDEX((DOCNO!$I$3:$I$5000=D3)*(DOCNO!$K$3:$K$5000=S3)*(DOCNO!$R$3:$R$5000=M3)|0)|0)|1))


Requirements:

1. ABF_Records pulls document number from DOCNO if it matches the NIIN, quantity on hand and condition code.
2. ABF_Records pulls multiple document numbers from DOCNO NIIN and codition code into appropriate Row/Cell (A3...).

Preference in order:

1. The multiple document numbers are concatenated into the appropriate Row/Cell (A3...etc).
2. The multiple documents are concatenated into a list box for the appropriate Row/Cell.


I have tried with my limited experience to concatentate, etc., but to save my marriage and sanity, I am asking for help again.

Thanks,

Michael.

Ben,

I wasn't looking for free development. I needed help understanding how to make the script work to concatenate into the formula.

My help request must be too difficult for the forum to help. I will figure it out on my own.

Thanks anyways,

Michael