Returning Multiple Values based on a VLOOKUP


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

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
Planned QtyActual QtyPlanned BatchActual BatchDifferenceDamagesStatusQty Per PalletNumber of Pallets

</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:

OIF IDDateTime TippedRaised byReceipt ReferenceReceipt PO NumberSending siteBatch AdvisedBatch SentItem Code AdvItem Code SentSent Item Code DescriptionMismatch Reason

</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.


Board Regular
Jun 29, 2018
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:

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...