Dave Peterson Wrote:
Put this in C1:

=INDEX($B$1:$B$8,MATCH(1,($A$1:$A$8=A1)*(LEN($B$1: $B$8)=2),0))

Dave Peterson

Dave I tried that and got a "#N/A".

I've uploaded my example file. It is very small ;)


+-------------------------------------------------------------------+
|Filename: ExampleFLUB.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4200 |
+-------------------------------------------------------------------+

--
flub
------------------------------------------------------------------------
flub's Profile: http://www.excelforum.com/member.php...o&userid=30322
View this thread: http://www.excelforum.com/showthread...hreadid=499850