One lookup option

[mpom]

I have a spreadsheet with four different options in one column and
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 i
associated with that original option. For exampl

A
16 24
22 24
16 24
36 24
30 24
30 24
16 24
26 24
22 24

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

Thanks

 

[Don Guillett]

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.

Your excel version is_______________