Forum home » Delegate support and help forum » Microsoft Excel Training and help » VLOOKUP
|
|
|
The UK's most regular 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VLOOKUP
Resolved · Low Priority · Version Standard
Reply Tue 18 Mar 2008, 16:05Delegate John said...
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"
For upcoming training course dates see: Pricing & availability
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
|