Returning Multiple Values based on a VLOOKUP

[paulpax84]

Hi Guys,
I am hopeful you can help me.
I am currently putting together a form which will draw information from a log based on a unique indicator (in this case OIF ID).
Please see below for the form:

[TABLE="class: grid, width: 860"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[/TR]
[TR]
[TD="colspan: 12"][/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[TD]OIF Type:[/TD]
[TD="colspan: 2"] [/TD]
[TD][/TD]
[TD="colspan: 3"]OIF Sender[/TD]
[TD][/TD]
[TD="colspan: 4"]OIF Receiver[/TD]
[/TR]
[TR]
[TD]OIF ID:[/TD]
[TD][/TD]
[TD] [DATA][/TD]
[TD][/TD]
[TD]Name:[/TD]
[TD="colspan: 2"] [/TD]
[TD][/TD]
[TD]To:[/TD]
[TD="colspan: 3"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Date:[/TD]
[TD="colspan: 2"] [/TD]
[TD][/TD]
[TD]Copy to:[/TD]
[TD="colspan: 3"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 8"]OIF Description (please include as much detail as possible and photographs if applicable)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 12"] [/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Incident Information[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Inbound Reference:[/TD]
[TD="colspan: 3"] [/TD]
[TD][/TD]
[TD="colspan: 2"]Inbound P/O:[/TD]
[TD="colspan: 3"] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Planned SKU[/TD]
[TD]Actual
SKU[/TD]
[TD]Planned Qty[/TD]
[TD]Actual Qty[/TD]
[TD]Planned Batch[/TD]
[TD]Actual Batch[/TD]
[TD]Difference[/TD]
[TD]Damages[/TD]
[TD]Status[/TD]
[TD]Qty Per Pallet[/TD]
[TD]Number of Pallets[/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col><col><col span="2"><col><col><col><col><col><col span="3"></colgroup>[/TABLE]

The user inputs a value in to the OIF cell (C6) and this populates the whole sheet. I have populated most of the sheet using VLOOKUPS but the section below “Incident Information” I am having trouble with. One “OIF ID” may have multiple issues with it and therefore multiple lines on the log which will need reporting on the “Incident Information” section individually. I have tried using an array formula containing the INDEX function but I cannot seem to get it to work.
The data is taken from a separate sheet title “Log” and is in the format below:

[TABLE="class: grid, width: 1494"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD="colspan: 2"]OIF ID[/TD]
[TD]Date[/TD]
[TD]Time Tipped[/TD]
[TD]Raised by[/TD]
[TD]Receipt Reference[/TD]
[TD]Receipt PO Number[/TD]
[TD]Sending site[/TD]
[TD]Batch Advised[/TD]
[TD]Batch Sent[/TD]
[TD]Item Code Adv[/TD]
[TD]Item Code Sent[/TD]
[TD]Sent Item Code Description[/TD]
[TD]Mismatch Reason[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col span="2"><col><col><col><col><col><col><col></colgroup>[/TABLE]

The “Log” sheet is input manually and the OIF ID is entered in to column B by the user. The data in the “Incident Information” section needs to come from the following columns of the “Log” sheet:
Planned SKU: K
Actual SKU: L
Planned Qty: Q
Actual Qty: R
Planned Batch: I
Actual Batch: J

All other columns in the Incident information would be formulated.

I hope this makes sense, apologies for the crude tables as examples.

Any assistance you can provide would be greatly appreciated.

 

[KolGuyXcel]

Share the INDEX formula that you are using.

Also, just a quick check. According to the table that is pasted here, C6 seems to refer to a cell with "OIF Description...". From which row is the table beginning?