Retrieve data based on Categories in Drop Down list

gogetter09 - Mar 17, 2016 at 12:51 PM

I have a sheet full of entries that have at least five columns full of different data. One of these columns is a drop down list of categories that the entry can fall under. Is it possible to gather individual columns of data based on their drop down category?

I have provided an example below:
(I'm trying to gather the currency amount dependent on the data from column 5)

e.g. Entry 1 (column 5 = drop down list)

3/1/16, Manager, UT, Various, $5, Full