Are you looking for an exact match?

If yes, the data doesn't need to be sorted.

The 4th parameter (false) must be specified, though.

wrote:

Thanks Dave. Unfortunately, the data in second file is NOT sorted.
Hence I cannot use vlookup. :(

--

Dave Peterson