vlookup

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » VLOOKUP

VLOOKUP

resolvedResolved · Low Priority · Version Standard

John has attended:
Excel Advanced course
PowerPoint Intermediate Advanced course

VLOOKUP

Is it possible to change the standard error message from #N/A to something more user friednly such as "No match" or "0"

RE: VLOOKUP

try mixing vlookup with IF statements:

=IF(ISERROR(VLOOKUP(B2,Range1,1,FALSE)),0,VLOOKUP(B2,Range1,1,FALSE))

Please find attached an example

Attached files...

Vlookup-example.xls

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Moving or Copying Sheets Between Workbooks in Excel 2010

Here's how to move or copy sheets between workbooks in Excel 2010:

Open the sheet you want to move or copy then on the Ribbon click the Home tab. Click Format. Under Organize Sheets, select the option Move or Copy Sheet and then choose where you want the sheet to be moved/copied to.

View all Excel hints and tips


Server loaded in 0.09 secs.