Why not rearrange the data on the lookups sheet.
Then create named ranges for all the items then use dependant validation on the software list sheet?

List the unique values in the Categories list horizontally, then place the items associated with them below them.
example:
graphics
convertor
chart/graph
other
suit

Windy