Member Login:
e-mail:
password:
Register
Forgot Password
Site FAQ
Home
>
IT Answers
>
Microsoft Windows
> VLookUp
BillOZ
5 pts.
VLookUp
Exact match VLookUp
,
VLOOKUP function
In a vlookup, what do I type in the formula so it shows “err” or something that indicates that the EXACT match is not found in the table?
Software/Hardware used:
Excel 2010
ASKED:
February 24, 2012 8:55 PM
UPDATED:
February 27, 2012 7:46 PM
Discuss
 
Add to Watchlist
RELATED QUESTIONS
eText template question
Ensuring the Data security by hosting the server @cloud?
Outlook 2007 Internet Calendars
Lotus script common name in agent with list and displaying database (urgent Please help)
DNS log filling with errors in Windows Server 2003
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki:
View Answer History
.
Please complete the following information:
REGISTER / LOG-IN TO ANSWER QUESTION
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Submit your e-mail address below to continue
E-mail: 
E-mail:
Company:
Handle:
Password:
Forgot Password?
Create Handle:
Your handle identifies you in IT Answers. Max 30 char.
Create Password:
Confirm Password:
Yes, I'd like to receive the IT Knowledge Exchange Community Newsletter
Yes, I agree to the
Terms and Conditions.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.
hidden modal window
RSS - Discussions
Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Please complete the following information:
REGISTER / LOG-IN TO DISCUSS
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Submit your e-mail address below to continue
E-mail: 
E-mail:
Company:
Handle:
Password:
Forgot Password?
Create Handle:
Your handle identifies you in IT Answers. Max 30 char.
Create Password:
Confirm Password:
Yes, I'd like to receive the IT Knowledge Exchange Community Newsletter
Yes, I agree to the
Terms and Conditions.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.
hidden modal window
Ask a Question
Question Title:
(150 char. limit.)
Question:
(Please be specific.)
Tags:
(Separate each tag with a comma.)
What is a Tag?
Browse IT Answers by Topic
AS/400
Big Data
Business Intelligence
Channel
CIO
Cloud Computing
Consumerization
CRM
Database
DataCenter
Development
Exchange
Linux
Lotus Domino
Microsoft Windows
Mobile
Networking
Oracle
SAP
Security
SQL Server
Storage
Virtualization
VoIP
Windows Server
>>
VIEW ALL TAGS