I made a logical error copying that forumula over originally, but when I
figured that out it worked.

And yes, that's doing exactly what I wanted... thanks.

"pinmaster" wrote:

>
> Hi,
> Not sure this is what your looking for but try this:
> =IF(COUNTIF(A:A,C3)>0,VLOOKUP(C3,A3:B10,2,0),"")
>
> A3:B10 being the range containing the names and id numbers.
>
> HTH
> JG
>
>
> --
> pinmaster
> ------------------------------------------------------------------------
> pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
> View this thread: http://www.excelforum.com/showthread...hreadid=474127
>
>