On Jul 27, 4:16 pm, Toppers wrote:
Check data for additional blanks: use TRIM function to remove. Retype an
entry and see if MATCH still fails.


Thanks Toppers. Let me elaborate my case:

Master files are A & B:
A.xls
name1 emp-id1
name2 emp-id2
.....

B.xls
name1(from A) emp-id1(from A) group1
name2(from A) emp-id2(from A) group2
........

C.xls
name1(from A) group1(from B)
name2(from A) group2(from B)
.......

In C, the entry is selected using a dropdown list DV'ed from name
extracted from A.
The result in C should extract data (Group) from B (with matching
name).

But, for some set of data (Group), I get #N/A in file C instead of the
group.

However, when I open B.xls, groups get updated!!

I am really puzzled.