In excel2007, I'm having 2 files. In file#1, in Sheet1, Column A contains
some names. In file#2, in Sheet1, Column D contains same (Case Matching)
names but in DIFFERENT ORDERS & Column E contains some numerical values
against each names.
In file#1, in Sheet1, in Column H, How to get the same numerical values
(Column E of file#2) against the names in Column A?
Note: File#2, Column D may contain ADDITIONAL names also(for which there is
some value in Column E).

Please help without VBA i.e. thr' excel functions
Sandeep