Returning Multiple Values based on a VLOOKUP

paulpax84

New Member
Joined
Jan 11, 2017
Messages
4
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:

ABCDEFGHIJKL
OIF Type: OIF SenderOIF 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 SKUActual
SKU
Planned QtyActual QtyPlanned BatchActual BatchDifferenceDamagesStatusQty Per PalletNumber 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:

ABCDEFGHIJKLMN
OIF IDDateTime TippedRaised byReceipt ReferenceReceipt PO NumberSending siteBatch AdvisedBatch SentItem Code AdvItem Code SentSent Item Code DescriptionMismatch 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.
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
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?
 
Last edited by a moderator:
Upvote 0

Forum statistics

Threads
1,213,539
Messages
6,114,221
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top