You can write a custom function, which calls VLookup itself with the
parameter you gave and check if it returns the "N/A".

The syntax is as follows :

Application.WorksheetFunction.VLookup(....)


---
Message posted from http://www.ExcelForum.com/