View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marko Ramius
 
Posts: n/a
Default Return cell value only once

I am trying to do the following

E.g.

Alligator 1
Bear 1
Cheetah 1
Deer 1

Imagine the above is two column with a column of names (Col A) and the other
of values (Col B). I managed to put in a function in another cell whereby it
will look up Col B to look for value "1". If the value is "1" the cell will
display the corresponding name, i.e. Deer. However, the problem is when I
put in another cell looking for another name whose corresponding value is 1,
it returns Deer. How do I avoid this problem so that it will return me a
value that has not shown yet?