Try VLOOKUP...See the Help files for details on its use.

=VLOOKUP(A1,FIND,3,0) where A1 is the cell containing the value to
look for, 'FIND' is the range name to look in for the value in A1, '3'
is the column within the range to return the value if lookup is found,
'0' says to find an exact match

Good Luck


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=465487