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