Originally Posted by mpom

I have a spreadsheet with four different options in one column and I want to have the function look-up one specific option from that four. And when it has that option to show the multiple outputs that is associated with that original option. For example

A B
16 246
22 249
16 247
36 244
30 247
30 248
16 246
26 247
22 248

I want the equation to show the outputs associated with every "16" in column A, but I don't want it to repeat those outputs. So for "16" in Column A I would like it to only show "246" once.

Thanks.