Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return value in cell above the reference | Excel Discussion (Misc queries) | |||
help with index to return particular cell value | Excel Discussion (Misc queries) | |||
Vlookup return 0 when cell is blank | Excel Worksheet Functions | |||
How do you make cell 2 return data if cell 1 contains text? | Excel Discussion (Misc queries) | |||
Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) |