Home |
Search |
Today's Posts |
#1
|
|||
|
|||
match index?
this is my problem: A B 1 ann 2 bob 3 catie 1 ann in clm B, the names are in a drop-down list . So in the last row, once ann is assigned, it is possible in A4 that it returns the number that has been previously assigned to ann? so if i key in catie in B5, A5 should return 3. -- cjjoo ------------------------------------------------------------------------ cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916 View this thread: http://www.excelforum.com/showthread...hreadid=477774 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match or Index Question | Excel Worksheet Functions | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Match & Index | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |