Good Morning All!
I believe I need to use an Index/Match/Offset Feature in my sample sheet attached but I do not understand how to build it and I request your aid in this.
In the sample attached, Sheet X1 is my master copy of information which in the live version is updated record by record which is four lines in total and each record has its own reference number.
In sheet Look Up Search, I want to be able to type in a reference number in the in H4 and it return the information from any four lines linked to that reference number in Sheet One
In the Look Up Search I am having difficulty in replicating Row 12 from sheet X1.
If the reference number was to change, for example to 1 of 29/11/17 then I would like Rows 17 to 20 of X1 to be replicated in Look Up Search rows 9 to 12.
I hope I have given enough information for you to help me
Thank you in advance.
Bookmarks