Thank you guys for your immediate reply, but it gave me a blank that
means it didn't found anything matches that I required.

For more explanation about my request is:

A6:A57 (Is the list of Employee Names)
B6:B57 (Is the Employee ID Number)

F7 (To enter the Employee ID Number required, then when it matches any
number in B6:B57, then the Employee Name appears. Also note that F7 is
located to another sheet within that File.)

It is like using "Query" in MS Access.


--
aries0070
------------------------------------------------------------------------
aries0070's Profile: http://www.excelforum.com/member.php...o&userid=25077
View this thread: http://www.excelforum.com/showthread...hreadid=385937