try this

=INDEX(Sheet2!$E$2:$E$10,MATCH("*"&Sheet1!A2&"*",S heet2!$D$2:$D$10,0))



On Oct 23, 7:45*am, Sandeep wrote:
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