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
Bookmarks