You don't provide a lot of context information (or a reprex
), so I have to guess here.
Your data is in a data.frame, your columns are named Col1, Col2, ... Your key is in Col2, the data you want is in Col4
To get Low: , you can use plain ol' R:
data$Col4[data$Col2 == 'Low:']
To get the full rows you can use
subset(data, Col2 %in% c("Low:", "Average:", "High:", "Median:"))
cheers
Steen