Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Daily Dose of Excel » VLOOKUP

VLOOKUP

As you know, the fourth argument of the VLOOKUP worksheet function determines whether VLOOKUP finds an exact match or an approximate match. If you set the last argument to False, and there is no exact match in the lookup list, the formula will return #N/A!. In Excel 2003, the best way to capture this error, [...] Read More...

Read the complete post at http://www.dailydoseofexcel.com/archives/2009/04/20/vlookup/

Posted Apr 20 2009, 10:37 AM by Daily Dose of Excel
Filed under:
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.