I have a list of medical procedure codes that need to be cross
referenced. The simple Vlookup function works, but some of the
descriptors have multiple outputs i.e. Brown, 2340 Brown, 2475

I want to create an output on different columns for different codes
(i.e. first code first column, etc.)

Brown, 2340, 2475

So far I have (second column)
=IF(COUNTIF(B:B,B51)=2,=VLOOKUP(B51,$B$1:$C$3740,2 ,FALSE),"")

But that does not seem to output correctly and it does not lookup the
correct value. I need the second value for the same name to output and
then I would change the countif number for the multiple number of codes
to output... I'm confused are you?


--
Whnke
------------------------------------------------------------------------
Whnke's Profile: http://www.excelforum.com/member.php...fo&userid=9677
View this thread: http://www.excelforum.com/showthread...hreadid=521498