I do not have great knowledge of excel. Can you show that How can I use
vlookup function to find related data from one file to another file. For ex.
file 1 have emp no and file 2 have emp no and emp name. I want to find
related name for emp no for file 1. I think it can be done by vlookup
function as all name and nos. are not in same order.

See http://www.contextures.com/xlFunctions02.html

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Kam" wrote in message
...
I do not have great knowledge of excel. Can you show that How can I use
vlookup function to find related data from one file to another file. For
ex.
file 1 have emp no and file 2 have emp no and emp name. I want to find
related name for emp no for file 1. I think it can be done by vlookup
function as all name and nos. are not in same order.