Dears,

I failed to get the full name of the student by looking at the full listings file with using Vlookup.
It shows #REF any time.

Attached is an examples.

getfull.xls - the enquiry file
nlookup.xls - the full lists

Anybodies could help me?

Getfull.xlsnlookup.xls

Kevin