Hi All,

Basically I have an excel sheet of data, and I would like to represent this data in other layout (template) so that it is easier for a someone to read.

The basic two functions it must do:

a) able to only pull the necessary data
b) able to select a different column of data when referring to it.

I've attached a small example of what i'm trying to achieve more or less.

Any help will be greatly appreciated, ive tried Index, Match, V and Hlookup functions and just cant come right.

Regards,

Jason

Example.xlsx