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:
<tbody>
</tbody><colgroup><col><col><col span="2"><col><col><col><col><col><col span="3"></colgroup>
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:
<tbody>
</tbody><colgroup><col><col><col><col><col><col span="2"><col><col><col><col><col><col><col></colgroup>
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.
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:
A | B | C | D | E | F | G | H | I | J | K | L |
OIF Type: | OIF Sender | OIF Receiver | |||||||||
OIF ID: | [DATA] | Name: | To: | ||||||||
Date: | Copy to: | ||||||||||
OIF Description (please include as much detail as possible and photographs if applicable) | |||||||||||
Incident Information | |||||||||||
Inbound Reference: | Inbound P/O: | ||||||||||
Planned SKU | Actual SKU | Planned Qty | Actual Qty | Planned Batch | Actual Batch | Difference | Damages | Status | Qty Per Pallet | Number of Pallets | |
<tbody>
</tbody><colgroup><col><col><col span="2"><col><col><col><col><col><col span="3"></colgroup>
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:
A | B | C | D | E | F | G | H | I | J | K | L | M | N |
OIF ID | Date | Time Tipped | Raised by | Receipt Reference | Receipt PO Number | Sending site | Batch Advised | Batch Sent | Item Code Adv | Item Code Sent | Sent Item Code Description | Mismatch Reason | |
<tbody>
</tbody><colgroup><col><col><col><col><col><col span="2"><col><col><col><col><col><col><col></colgroup>
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.