Hi,
Yes. If you use the 4th argument and set it to FALSE.
=VLOOKUP(LookupValue,LookupTable,ColumnToReturn,FA LSE)
By using the FALSE argument, VLOOKUP looks for an exact match only, and
doesn't need the table to be sorted alphabetically.
However, if VLOOKUP doesn't find the LookupValue you give it, it returns a
#N/A error, which you can trap for if you want.
=IF(ISNA(VLOOKUP(LookupValue,LookupTable,ColumnToR eturn,FALSE),"Lookup Value
Not Found",VLOOKUP(LookupValue,LookupTable,ColumnToRet urn,FALSE)

Regards - Dave.