Excel heavy data - Pivot - VLookup Required

[cobrabear]

Hello,

I have a quite intense (some may think its pretty basic) excel document, which shows information within it that I am looking to condense into a pivot/vlookup basis.

There are multiple sheets (within a workbook) - so i am trying to have a 'link' feature to do this correctly.

its also been made a little harder as within the worksheet, the headers have been split into sub columns, so when trying to create a table 'column 1' appears.

Any experts that know this inside out, if possible to provide any help, or if you require me to upload the documents so you can see what it looks like and exactly what im referring to would be great.

many thanks in advance

[cobrabear]

in a nutshell, both excel workbooks uploaded; my aim is to create a form of pivot table and/or vlookup which consolidates the whole info into one manageable, clickable, drop down function; in which i am having difficulties in doing, due to the columns having dual columns within them and non selection/linking of relationship error

attachments provided to give scope and insight

[alansidman]

crossposted: https://www.mrexcel.com/board/thread...uired.1154864/

Rule 03: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future

[cobrabear]

Apologies and many thanks,

[JeteMc]

A way to accomplish this using formulas might be to add a row to the summary sheet and put the column numbers from which the data will be indexed.
In the attached copy of the file the column numbers are in row 1. Note that the column numbers could be moved to another row or hidden either by hiding the row or changing the font to white.
The formula that fills in the summary is: =INDEX(Singapore!$A$10:$AL$40,MATCH($A5,Singapore!$D$10:$D$40,0),B$1)
Let us know if you have any questions.