One lookup option
 

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.

If you're using 2007 or later there's a "remove duplicates" option in the ribbon that will do what I think you mean.

I appreciate the answer. I'm also lost on how to set up the equation to pull the "16" in column A and then pull all the outputs in Column B associated with that "16".

For Example I would like the equation to have an output of:
246, 247

One lookup option
 

On Thursday, September 13, 2012 3:53:48 PM UTC-5, mpom wrote:
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.









--

mpom
Your excel version is_______________