LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Return value in cell above the reference Jean Excel Discussion (Misc queries) 4 May 31st 06 07:50 PM
help with index to return particular cell value Allan from Melbourne Excel Discussion (Misc queries) 0 May 27th 06 03:20 AM
Vlookup return 0 when cell is blank Paul Excel Worksheet Functions 2 January 11th 06 05:01 PM
How do you make cell 2 return data if cell 1 contains text? jermsalerms Excel Discussion (Misc queries) 3 January 5th 06 10:44 PM
Select cell, Copy it, Paste it, Return to Previous cell spydor Excel Discussion (Misc queries) 1 December 30th 05 01:29 PM


All times are GMT +1. The time now is 08:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"